Hi,
The following is part of an SQL union, the problem is that I am getting two duplicate records instead of one.
As far as I was aware UNION enliminates duplicates, whereas UNION ALL with give you all records
Both tables are identical i.e. a main transaction file and an archive file
Select Table1.field1, COUNT(*) as total ;
FROM Table1 ;
GROUP BY 1 ;
UNION ;
select Table2.field1, COUNT(*) as total ;
FROM Tabel2 ;
GROUP BY 1 ;
order by 1 ;
INTO Cursor curCursor1 nofilter
Thanks in advance
Regards N Mc Donald