Reverse the Result of SQL Statement

[simeybt]

All,
What i looking to do is to get all the records on one table that don't have a matching code in an other table. ie
SELECT A_Table.*
FROM A_Table, B_Table
WHERE A_Table.code <> B_Table.code;

but this doesn't work

Any ideas

 

[scriverb]

You should be using a Left Join to accomplish this:

SELECT A_Table.*
FROM A_Table LEFT JOIN B_Table ON A_Table.code = B_Table.code 
WHERE IsNull(B_Table.Code);

This should give you what you are looking for.

Bob Scriver
[blue]Want the best answers? See FAQ181-2886[/blue]

 

[simeybt]

Worked a treat thanks

Simon