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

advertisement

AddThis Social Bookmark Button
Article:
  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
projects.


can anyone answer this please...




1 to 1 of 1
1 to 1 of 1