On Thu, Feb 28, 2008 at 4:21 PM, danyschaer <schaer@...> wrote:

> Hi Helen,
>
> I agree with you 100%.
>
> And in my case, I use this type of sintaxis because it guives me the
> ability to combine that sets in diferent ways, on the fly.
> For example, we can use (in other dialects, no firebird) INTERSECT or
> MINUS, instead of using UNION, and in that way we can easely change the
> query to find exactly what the user is needing.
>
> Unfortunatly Firebird does not have INTERSECT or UNION ...

Firebird does have UNION. Did you mean MINUS?
They will eventually INTERSECT and MINUS, which according to the
standard are INTERSECT and EXCEPT. I think I got that right.
;)

Fidel.