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)