>I have two tables in which I keep Employee records one has direct employees the other contractors. They both have same field structure. I need to total count of records from both tables combined. These are remote tables an I access then with SPT.
>
>I have tried UNION ALL but this gives me two records, the count from each table.
Use it as derived table to get Total
SELECT SUM(counts) FROM (
SELECT SUM(...) ...
UNION ALL
SELECT SUM(...) ...
) dt1
--sb--