select (select col_Description from COL1 where col1=a.col1) col_Description1,
(select col_Description from COL1 where col2=a.col2) col_Description2
from Sample a
(select col_Description from COL1 where col2=a.col2) col_Description2
from Sample a
select col1,col2,
(select col_description from col1 where col1=sample.col1) as col1Des,
(select col_description from col2 where col2=sample.col2) as col2Des
from sample