>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