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

Best regards,

Dany