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