Home
Browse Code Add-Ins Blog Language Feeds Service Stats FAQs Feedback About
Manage Your Code
Snippet: Update Table with Join (SQL)
Title: Update Table with Join Language: SQL
Description: Updates fields on one table from data on other tables via a Join Views: 1607
Author: Andrew Faust Date Added: 2/4/2008
Copy Code   
update t1 
	set t1.Field=t2.Field 
from Table1 t1 
join Table2 t2 on t1.id=t2.id
Usage 
Nothing spectacular about it. I simply keep forgetting the exact syntax and needing to look it up