Derived table in the Select statement

[jliang]

Hi,

I need write a sql like:

select case when a.col1 in (select col1 from table2)
then 'ok' else 'fail' end
from table2 b

Can I pass a derived table in this statement?

Many thanks in advance

Jing

 

[ChandruN]

try this


select case when a.col1 = b.col1
then 'ok' else 'fail'
end
from ( table1 a left outer join table2 b on
a.col1 = b.col1 )