;WITH KeyCTE
AS (SELECT GovState, FirmID FROM #t1
    UNION
    SELECT GovState, FirmID FROM #t2
    UNION
    SELECT...

• This reply was modified 5 years, 2 months ago by  tjolliffe.