Home
Browse Code Add-Ins Blog Language Feeds Service Stats FAQs Feedback About
Manage Your Code
Snippet: UPdate id via join on FK (SQL)
Title: UPdate id via join on FK Language: SQL
Description: Example of how to update an id field in a table by joining it on a field that it shares with another table. Views: 78
Author: Trey Carroll Date Added: 3/10/2010
Copy Code   
USE _SCRATCH
UPDATE dbo.JapanAscentImport3_10_2010 
SET o_ID = OPT.O_ID 
FROM TISOPV2.DBO.OPTIONEES AS OPT 
JOIN dbo.JapanAscentImport3_10_2010 AS JAI 
ON OPT.[PARTY ID] = JAI.[PARTY ID]
Usage 
Many tisop updates.