SELECT “Total“ AS Col1, “ “ AS Col2, “ “ AS Col3, Count([TableA.Column1]) AS [Count_TableA_Column1], 2 as roworder

FROM…TableA INNER JOIN TableB INNER JOIN TableC

UNION

SELECT TableB.Col1, TableB.Col2, TableB.Col3, Count([TCPIP Table].[Term #]) AS [CountOfTerm #],1 as roworder

GROUP BY TableB.Col1, TableB.Col2, TableB.Col3

ORDER BY roworder,Col1, [Count_TableA_Column1]