>Pass, but it's interesting to note that given the EXISTS form of the query,>DB2 optimises it to the same query as before.>>>Original Statement:>------------------>SELECT P#, PNAME>FROM P>WHERE EXISTS> (SELECT *> FROM SP> WHERE P.P# = SP.P#)>>>Optimized Statement:>------------------->SELECT DISTINCT Q2.P# AS "P#", Q2.PNAME AS "PNAME">FROM DB2.SP AS Q1, DB2.P AS Q2>WHERE (Q2.P# = Q1.P#)>