[SQL] NOT-IN CLAUSE

[Prashant Dalal]

Hi,

My Following select st. is running from last one day. I think the problem is
NOT IN clause.
Please suggest the alternative select clause.



SELECT resreq.proj, resreq.ver, substr(resreq.act, -5, 5) act, resreq.rn,
null, 
       null, resreq.rl, resreq.dr, resreq.ra
    FROM resreq
    WHERE resreq.ver IN ('0', '99')
      AND NOT (resreq.proj, resreq.ver, substr(resreq.act, -5, 5),
resreq.rn)
          IN (SELECT actres.proj, actres.ver, substr(actres.act, -5, 5) act,

                      actres.rn
               FROM actres, resreq
               WHERE actres.proj = resreq.proj
                 AND actres.ver = resreq.ver
                 AND substr(actres.act, -5, 5) = substr(resreq.act, -5, 5)
                 AND actres.rn = resreq.rn
                 AND actres.ver IN ('0', '99'))




Best Regards,
Prashant Dalal.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~
LaborLogix

<<attachment: winmail.dat>>

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster