Subject Re: [firebird-support] How can I combine these two queries into one?
Author Alexandre Benson Smith
Post date 2007-01-09T03:22:21Z
Anthony Tanas wrote:
> Yep that was it! But what's the difference between UNION and UNION ALL?
>
>
> W. Anthony Tanas
> Systems Analyst/Architect/Programmer
>

Union will remove the duplicated rows.

union all will displa all rows.

see you !

--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br