to ask a question on join using insert statement

Question

question

java asked Feb 2, '10

to ask a question on join using insert statement

hello,can u plz tell me how to use insert statement using join with a proper example.normally we use joins with select statement .

t-sql performance

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2010-02-02T04:28:10Z

Scot Hauder answered Feb 2, '10

INSERT #tmp (col1,col2)
SELECT a.col1,b.col1
FROM table1 a
JOIN table2 b ON (a.ID = b.ID)

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 2 · 2010-02-02T04:27:10Z

Steinar answered Feb 2, '10

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?

1

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

java commented · Feb 03, 2010 at 03:48 PM

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

0 ·

question