View Full Version : Need some SQL help

05-16-2006, 04:09 PM
Hello all. I have two tables (Equipment and Divisions). The Divisions table contains all valid division codes, and the Equipment table has the equipment numbers along with the corresponding division code. The problem is that many of the equipment were put in throught the back-end, therefore no error checking took place. What I need to do is to create a query that will go through the Equipment table and find any Divisions that do not exist in the Divisions table. I have tried various joins, Union, etc, but I can't seem to figure it out.

Any help would be greatly appreciated,