使用oracle 11g联合所有查询

select x,y
from table 1, table 2
where table1.location = 'IL' and table1.col1 = table2.col1 
union all 
select x,y
from table 1, table 3
where table1.location = 'NY' and table1.col2 = table3.col2 
union all 
select x,y
from table 1, table 4
where table1.location = 'KY' and table1.col1 = table4.col1 
union all 
select x,y
from table 1, table 5
where table1.location = 'TX' and table1.col1 = table5.col1 
select x,y
from table 1, table 2
where table1.l