Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

SQL Problem

 
Tony Evans
Ranch Hand
Posts: 597
1
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
This is a SQL not a java problem, if someone could point me towards a SQL website similar to this i would be happy or if you can solve this problem I would be even happier.
I have two tables EMPLOYEE and WORKING, I want to display all employees mot working. I use the folling SQL Code>
select emp.employeeID, emp.name
from EMPLOYEE emp,WORKING wk
where wk.employeeID != emp.employeeID

What it returns is all employees not working plus all the employees. So I am getting two lots of data returned.
e.g if Tom Smith is working, James Thomas and Sara Hall are not I get returned
James Thomas
Sara Hall
Tom Smith
James Thomas
Sara Hall
I used to know how to solve this problem but I have forgotten.
Thanks for any help.
Tony
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 33697
316
Eclipse IDE Java VI Editor
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Tony,
You need a subquery:
 
Tony Evans
Ranch Hand
Posts: 597
1
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks this SLQ code worked.
Tony
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic