Subject Re: Union statement automatically adds 'DISTINCT'?
Author Adam
> I just wanted to make sure that I'm correct in my assumption of the
> union clause. I'm using FB 1.5.3.

Hello Paul,

Yes, union does remove duplicates, by design.


In SQL the UNION operator combines the results of two SQL queries into
a single table of all matching rows. The two queries must have
matching fields and data types in order to join them. Any duplicate
records are automatically removed unless UNION ALL is used.

Firebird behaves consistently with the SQL standard and consistently
when compared to other DBMS. Union All will give you what you want.