Hi Nioco,

me again.

Nico Callewaert schrieb:

>
> 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 ?

How about reversing the join from Table2 to Table1?

SELECT * FROM TABLE2 B
JOIN TABLE1 A ON B.FIELD = A.FIELD

????

Luc.