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
