This week's book giveaway is in the General Computing forum. We're giving away four copies of Arduino in Action and have Martin Evans, Joshua Noble, and Jordan Hochenbaum on-line! See this thread for details.
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