>>;with cte as (select sum(Amount) as ProgramTotal, [Year] >>from ProposedFunding >>where tipID = 92.04 and FundType = 'RTA' >>GROUP BY [Year]) >> >>select F.*, F.Jan +F.Feb + ... as Total, cte.ProgramTotal >>from cte LEFT JOIN [RTA-PmtForecast] F on cte.[Year] = F.[_year] and F.TipID = 92.04 >>order by cte.[Year]