Hi,
I guess you want to do this:
select
from table1
(This is true if Table2.col1 is unique)
I guess you want to do this:
select
table1.col1,
table1.col2,
(select table2.col2 from table2 where table1.col1=table2.col1),
(select table2.col2 from table2 where table1.col2=table2.col1)
from table1
(This is true if Table2.col1 is unique)