INSERT #tmp (col1,col2) SELECT a.col1,b.col1 FROM table1 a JOIN table2 b ON (a.ID = b.ID)
answered Feb 02, 2010 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, 2010 at 04:27 AM