I need to join three tables but there is no common fields for first table. There is one common field called 'bipad' between second and third table.
I need to join three tables as like below code without any condition. How to achieve it?
I'm getting error when I ran the code below.
select WH_NO,WH_NAME,CITY_NAME,STATE_ALPHA from MASSH.ACCOUNT
union
select sum(copies) as totalcopies from EMS.TBK_WS_DRAW_SALE_TRANSACTION where bipad in (10227,32686)
union
select ISSUE_NAME,ISSUE_NO,ONSALE_DATE,OFFSALE_DATE from MASSH.ISSUE where bipad in (10227,32686) and (ISSUE_YEAR=2015);