INSERT #tmp (col1,col2) SELECT a.col1,b.col1 FROM table1 a JOIN table2 b ON (a.ID = b.ID)
answered Feb 02 '10 at 04:28 AM
Can you please provide more information about what you want to do? What does the tables look like? What data do yu want to insert?
answered Feb 02 '10 at 04:27 AM