This week's book giveaway is in the Java 8 forum.
We're giving away four copies of Java 8 in Action and have Raoul-Gabriel Urma, Mario Fusco, and Alan Mycroft on-line!
See this thread for details.
The moose likes JDBC and the fly likes SQL Problem Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Java 8 in Action this week in the Java 8 forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "SQL Problem" Watch "SQL Problem" New topic

SQL Problem

Tony Evans
Ranch Hand

Joined: Jun 29, 2002
Posts: 556
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,
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.
Jeanne Boyarsky
internet detective

Joined: May 26, 2003
Posts: 29287

You need a subquery:

[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
Tony Evans
Ranch Hand

Joined: Jun 29, 2002
Posts: 556
Thanks this SLQ code worked.
I agree. Here's the link:
subject: SQL Problem
Similar Threads
xsd : defining array
Need help on creating tables for a simple scenario
How to achieve runtime polymorphism in Java
Collection in java
I am able to display the file information, but I am having problem displaying the employee details.