create view
select
table2.colum1,table2.colum2,table2.colum3,table2.colum4,table1.colum1,table1.colum2
from table1,table2
where table2.colum2 = table1.colum1
select
table2.colum1,table2.colum2,table2.colum3,table2.colum4,table1.colum1,table1.colum2
from table1,table2
where table2.colum2 = table1.colum1
select table2.colum1,table2.colum2,table2.colum3,table2.colum4,table1.colum1,table1.colum2
from table1,table2 where table2.colum2 = table1.colum1;