I have 4 archive tables and 1 active table that are created the same, but contain different data based on the date. I need to get results that have three columns: AuthorName, Month, Total. This is currently working, but through my research I can't find how to start going about dealing with the fact that each Author has some of his results from one month in one table and some in another table and how to add those together into one row. Example:(What I'm Getting)AuthorName Month TotalTest, Fred 3 43Test, Fred 3 12Test, Fred 2 56Test, Fred 5 35(What I Want)AuthorName Month TotalTest, Fred 3 55Test, Fred 2 56Test, Fred 5 35------------------------------------SELECT AuthorName, Month(CreateDT) as Month, COUNT(*) AS Total FROM [FM].[dbo].[WORKOBJ]Where CreateDT >= '2013-01-01' and CreateDT <= '2013-12-31' GROUP BY AuthorName, Month(CreateDT)Union AllSELECT AuthorName, Month(CreateDT) as Month, COUNT(*) AS Total FROM [FM].[dbo].[Q1Tasks2013]Where CreateDT >= '2013-01-01' and CreateDT <= '2013-12-31' GROUP BY AuthorName, Month(CreateDT)Union AllSELECT AuthorName, Month(CreateDT) as Month, COUNT(*) AS Total FROM [FM].[dbo].[Q2Tasks2013]Where CreateDT >= '2013-01-01' and CreateDT <= '2013-12-31' GROUP BY AuthorName, Month(CreateDT)Union AllSELECT AuthorName, Month(CreateDT) as Month, COUNT(*) AS Total FROM [FM].[dbo].[Q3Tasks2013]Where CreateDT >= '2013-01-01' and CreateDT <= '2013-12-31' GROUP BY AuthorName, Month(CreateDT)Union AllSELECT AuthorName, Month(CreateDT) as Month, COUNT(*) AS Total FROM [FM].[dbo].[Q4Tasks2013]Where CreateDT >= '2013-01-01' and CreateDT <= '2013-12-31' GROUP BY AuthorName, Month(CreateDT)Order By AuthorName, Month(CreateDT)