Helen,

Unfortunately your assertion is not true, a UNION can return a set
containing any number of rows including 0 and 1.


Sean

-----Original Message-----
From: Helen Borrie [mailto:helebor@...]
Sent: Friday, February 23, 2001 9:43 PM
To: ib-support@yahoogroups.com
Subject: Re: [ib-support] UNION

<snip>

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.