Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: SQL Server
Expertise: Beginner
Mar 24, 1997

Finding Data that's in One Table but not Another

Question:
I have an employee table with a field empno (employee number) and an hours table that contains all time that is worked by all employees. The hours table has the empno field also. What I am trying to do is get a list of inactive employees; that is, all employees that haven't any entries in the hours table. Is there a simple way to do this?

Answer:
Sure. Try something like this:

SELECT empno FROM Employees
     WHERE empno NOT IN (SELECT empno FROM Hours);
DevX Pro
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date