At 02:18 AM 24-02-01 +0200, you wrote:

>Hi everybody !
>Is it true that union clause doesn't work with singleton selects ?
>Dorin

Ummm...yes...

Union outputs a set of at least 2 rows (it's the union of multiple selects).
A singleton select is 1 row max (otherwise it's not a singleton!).

H.

All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________