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...