Declare @Table table

Populate it using "query"

Add rows to @Table using

select query.............

join some query ................

join @Table on some query

Repeat.