Hi list,

I will make my question clear with an example : I have 2 tables with a me data like this :

Table1 Table2
----------------------------------
LAS LAS
DRA DRA
COL COL
SNY <--- That's the record I would like to retrieve....

So, to retrieve the common data from the tables is easy with a join, but what if I like to retrieve all the records from table 2 that don't exists in table 1. I there a way to do that ?


Many thanks in advance,

Nico Callewaert


[Non-text portions of this message have been removed]