Hi I have 2 (and more) tables with identical structure:
Simplified structure and data: CODE VARCHAR(15) QUAN INTEGER Table A Item1, 50 Item1, 40 Item2, 70 Table B Item1, 50 Item2, 100 Item2, 30 I need to get the sum(QUAN) for all the rows in all the tables group by CODE Item1, 140 Item2, 200 Is there a way I can do it with a UNION? Or is there a better way? Regards Cornie van Schoor InfoStar Software