[SOLVED] Stuck on a query

[tommo74]

I'm stuck on a query for a while now, maybe somebody could help.

 

If I have two tables, say Table1 and Table2, and they both have a column called Code. I want to select everything from Table1 where there is data in the Code column in Table1 that is'nt in the Code column in Table2.

For example if all the data is the same in both columns except Table 1 has one entry in the Code column thats not in the Table2 Code column, how would I select that one row from Table1 ?

 

Thanks

 

[beebum]

SELECT Table1.Code FROM Table1

LEFT JOIN Table2 ON Table1.Code=Table2.Code

WHERE Table2.Code IS NULL;

[tommo74]

Thanks !