Women in Technology

Hear us Roar


Article:
  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)

Recommended for You
 
Sign up today to receive special discounts,
product alerts, and news from O'Reilly.
Privacy Policy >
View Sample Newsletter >