Subject Re: [firebird-support] unions in sub-selects
Author Aage Johansen
Helen Borrie wrote:
> At 12:04 AM 10/02/2005 +0100, you wrote:
>
>
>
>>Maybe "union all" will work? Since "union" may return duplicates it
>>doesn't really make sense to allow this.
>
>
> UNION ALL may return duplicates. UNION alone discards duplicates.
>


AaaarrrrrrggggggggggggggggGgggggggghhhhhhhhhhhhhhhhhhhhhhhhhhhH!

Posting-too-late syndrome !


--
Aage J.