Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How-To Update Tables Using Inner Joins
T-SQL Hints and Tips
You've gone through the trouble of creating a select statement that joins a couple of tables together and discovered that some data needs to be updated. How can you do that when you've joined tables?
First, state that you're going to be performing an update...
Then join the tables that will meet the condition.
Then state what's going to change.
Then we add a WHERE clause.
Tie it all together...
Problem solved.
Good Luck,
MapMan![[americanflag]](/data/assets/smilies/americanflag.gif "[americanflag] [americanflag]")
Assume nothing, question everything, be explicit not implicit, and you'll always be covered
First, state that you're going to be performing an update...
Code:
UPDATE
Code:
TABLEA AS A INNER JOIN TABLEB AS B ON A.F1=B.F1
Code:
SET A.X = 1, B.Y = 2
Code:
WHERE A.Z =10
Code:
UPDATE TABLEA AS A INNER JOIN TABLEB AS B ON A.F1=B.F1
SET A.X = 1, B.Y = 2 WHERE A.Z =10Good Luck,
MapMan
Assume nothing, question everything, be explicit not implicit, and you'll always be covered