select a.*,
b.[Monthly Terms],
c.[Monthly TO],
d.[YTD Avg HC],
e.YTDTerms,
f.[YTD TO Ratio],
g.[Annualized TO]
from #tmp_month_headcount a
join #tmp_month_terms b on a.Id=b.Id
join #tmp_month_turnover c on b.Id=c.Id
join #tmp_ytd_hc_avg d on c.Id=d.Id
join #tmp_ytd_terms_cnt e on d.Id=e.Id
join #tmp_ytd_turnover f on e.Id=f.Id
join #tmp_annualized_to g on f.Id=g.Id
order by a.Id asc