HI,

How can i rewrite the below statement in DB2 UDB V 8.2 FOR WINDOWS,AIX.

select a.emp_name, b.dep_name
from EMP a,
DEP b
WHERE a.dep_id = b.dep_id (+)
AND b.active_ind (+) = 'Y'


Thanks
Thirumaran
Thanks

Thirumaran

DB2 & UDB email list listserv db2-l LazyDBA home page