|
hello,can u plz tell me how to use insert statement using join with a proper example.normally we use joins with select statement .
(comments are locked)
|
INSERT #tmp (col1,col2) SELECT a.col1,b.col1 FROM table1 a JOIN table2 b ON (a.ID = b.ID)
(comments are locked)
|
|
Hello! 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? there r two tables ,i just wana know whether we can make use of insert statement in joins or not.normally the query for joins is select a.name,b.address from abc a join asz b on a.id=b.id.but iwana make use of insert statement in join.,if its possible plz tell me the answer,with proper eg
Feb 03 '10 at 03:48 PM
java
(comments are locked)
|
Your answer
