Here is an example of inserting into a temporary table from multiple joins:
select a.col,b.col,c.col into #temp1
from table1 a
join table2 b on a.column1ID= b.column2ID
join table3 c on a.column1ID= c.column3ID
where c.col= ‘anydata’
Here is an example of inserting into a temporary table from multiple joins:
select a.col,b.col,c.col into #temp1
from table1 a
join table2 b on a.column1ID= b.column2ID
join table3 c on a.column1ID= c.column3ID
where c.col= ‘anydata’
SqlBird 