Hi All,



I am in need of a query without using a case statement in the
query listed below.



Here is the query:





select rw.rpm_with_id, case when dj.job_assignee_node_id =
rw.rpm_with_node_id then 'ASSIGNED' else 'UNASSIGNED'

end from daily_job dj, rpm_with rw

where rw.rpm_with_node_id =
dj.job_assignee_node_id





Thanks in advance.





Regards,

Jude


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