Join in Insert?

[jararaca]

Hi,

I have a table with an empty field that needs to be populated with data from a related table. In other words, if I do a join between this table and the related table, the value I need to populate the empty field with would be on the same row as the row that needs to be populated. I'm not sure how to do this, because I'm not sure how to do a join in an Insert statement.

Can anyone please help?

Thank you.

 

[vongrunt]

Write SELECT with JOIN first.
Test it.
Then add INSERT INTO .... before SELECT.
Voila.

Or maybe you need UPDATE with JOIN? Or both together?

------
"There's a man... He's bald and wears a short-sleeved shirt, and somehow he's very important to me. I think his name is Homer."
(Jack O'Neill, Stargate)

 

[SQLDenis]

to update the first table with the values from the second (related) table use something like this

update t1
set t1.field =t2.field
from table1 t1 join table2 t2 on
t1.id =t2.id

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[jararaca]

Thank you!

Yeah, I caught that kinda late. I did mean Update instead of Insert...