ONJava.com -- The Independent Source for Enterprise Java
oreilly.comSafari Books Online.Conferences.


AddThis Social Bookmark Button
  SQL Subqueries
Subject:   need answer..
Date:   2007-02-17 02:53:52
From:   rajii
i have related two tables.
table name are "usermanagementtable" and "projectstable"

usermanagementtable have Employeeid's of project manager,teamleader,associate projects.it has other coloumn called designation.(designation will be manager,teamleader,associate projects).

projectstable has project manager EmpID who are assigned to some projects.

here i set usermanagementtable Employeeid as primary key and projectstable Employeeid as foriegn key.

now i need projects manager empid from usermanagementtable where those id should not be in projects table..

that is project manager id's who has not assigned to any

can anyone answer this please...

1 to 1 of 1
1 to 1 of 1