Subject Re: [firebird-support] How do you get a summary SUM() from a union of tables
Author Mark Rotteveel
Post date 2012-07-02T18:22:57Z
On 2-7-2012 20:07, Cornie van Schoor wrote:

> Set thanks for the reply, I just have one problem, the union removes
> duplicates. So if both tables have
> Item1, 50
> the result is
> Item1, 50 and not
> Item1, 100 as I require.

Use UNION ALL instead of UNION.

Mark
--
Mark Rotteveel