SQL Subqueries
Subject:   answer for this
Date:   2007-04-02 21:44:52
From:   sethumeena
Response to: need answer..

if u this following subquery u can easily reteive the answer for ur question.i ve checked. u also check with program and inform.

select a.emplid,a.designation from usermanage_tbl a where a.designation='pm' and
a.emplid not in(select a.emplid from projectable_tbl b where a.emplid=b.emplid)