How To Join Tables Into A @variable

Hi. I'm doing a statistics of usage as a T-SQL on a MSSQL server. I would need to systematically 'stick' tables together.
lets say I have a @temptable:

Code:

DECLARE @temptable TABLE (YearM int, Period int)


and I have created another table

Code:

DECLARE @temptablecounts TABLE (YearM int, Period int, Count int)


Now I would like to make something like

Code:

@temptable = @temptable join @temptablecounts on YearM, Period


so I would get a table which looks like this:
Code:

@temptable (YearM, Period, Count)


That would I need to do a few more times, so finally I would get a table like:

Code:

@temptable (YearM, Period, Count, Count, Count ...) etc.


Is it somehow possible? Exists any other way to do what I need? Please help