Hi,
I am running a following query in DB2 and getting SQL0338n error.
This is primarily because, there are subqueries at few places (marked in bold)in the main query, after 'ON' clause.
Could anyone please help me, as how these subqueries can be replaced without change in resultset?

Thanks,
Tejas.



--------------------------------------------------------------------------------...