Hi Martijn,

In this case I can't do a Intersection between two Tables.
Is there some way to get a result set that is the same on the two tables
and then with this return only the record's that don't have on the two
table's, that are on table1 but not on table 2 and the inverse?

Tanks for the help.

----------------------------------------------------------------
Greetings,
Jean Derrie Rigo
rigo@...
----------------------------------------------------------------

----- Original Message -----
From: "Martijn Tonies" <m.tonies@...>
To: <firebird-support@yahoogroups.com>
Sent: Friday, December 12, 2003 12:00 PM
Subject: Re: [firebird-support] Intersection


> Hi,
>
> > Is there some kind to make a Intersection between two select's. On
> > Oracle I've made:
> >
> > Select Col1, Col2 from Table1
> > where .....
> > Minus
> > Select Col1, Col2 from Table1
> > where .....
> >
> > How can I make this on Firebird?
>
> Only via:
>
> > Select Col1, Col2 from Table1
> > where .....
> and ID not in (select ID from table1
> where <whereclause_2>
>
> With regards,
>
> Martijn Tonies
> Database Workbench - developer tool for InterBase, Firebird, MySQL & MS
SQL
> Server.
> Upscene Productions
> http://www.upscene.com
>
>
>
> To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>
>