Subject Re: [firebird-support] PROBLEMS USING UNION
Author Helen Borrie
At 11:05 PM 23/01/2005 +0800, you wrote:


>talk about UNION.
>
>Is there a difference in using UNION and UNION ALL in firebird?

Yes. UNION is synonymous with UNION DISTINCT, it eliminates duplicate
rows, while UNION ALL includes them.

./hb