I will give it a shot and let you know.

Thanks for it,

Nico

----- Original Message -----
From: Lucas Franzen <luc@...>
To: <ib-support@yahoogroups.com>
Sent: Friday, June 01, 2001 9:27 PM
Subject: Re: [ib-support] SQL design question


>
> 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.
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>