Posted by SQL on 10/01/47 11:27

Update t2 set color = t1.color
from Table1 t1
join Table2 t2 on t1.name =t2.name

http://sqlservercode.blogspot.com/

• Next in forum: Re: delete records
• Prev in forum: updating multiple fields
• Thread view: Re: updating multiple fields

[Reply to this message]