Rewrite an IN subquery as a join
Can someone help me with this please? Is there a way to rewrite the
following IN subquery as a join? Any help is much appreciated.
SELECT DISTINCT
p.processID
,p.processName
,p.highLevelOrder
FROM
tblProcess p
WHERE
p.highLevel = 1 and processID
in (select processID from tblJobCPR, tblJobTracking where
tblJobCPR.cprID = tblJobTracking.cprID and tblJobTracking.effectiveEnd
>= @processDate)
ORDER BY
p.highLevelOrder