Join different table columns into one using Azure SQL

This question is old and I am sure you already found a solution. I thought I would post a solution in case someone else has the same question. The tables needed to be unioned together. Because each table contains unique data, union all is the more efficient way to go.

SELECT [Location]
,[Date]
,SUM(TableACount) AS TableACount
,SUM(TableBCOunt) AS TableBCount
,SUM(TableCCount) AS TableCCount
FROM (
SELECT [Location]
,[Date]
,TableACount
,NULL As TableBCount
,NULL As TableCCount
FROM TableA
UNION ALL
SELECT [Location]
,[Date]
,NULL
,TableBCount As TableBCount
,NULL As TableCCount
FROM TableB
UNION ALL
SELECT [Location]
,[Date]
,NULL As TableACount
,NULL As TableBCount
,TableCCount
FROM TableC
) AS X
GROUP BY [Location], [Date]
ORDER BY [Date] ASC, [Location] DESC