How do I update a join query

Question

I have two tables that can be joined on a key. All I want to do is to update one of the attributes of table1 using a condition on table 2

UPDATE t1 
 INNER JOIN t2
    ON t1.id= t2.id
   SET t2.column3 = 'dte'  
 WHERE t1.column = 456

Possible duplicate of [How can I do an UPDATE statement with JOIN in SQL?](https://stackoverflow.com/questions/1293330/how-can-i-do-an-update-statement-with-join-in-sql) — Esteban P., Sep 21 '17 at 17:46
You should provide details of what you tried, what worked and what didn't.. And question has to be very specific — tired and bored dev, Sep 21 '17 at 17:46
@user2023608 Microsoft sql server. I'm a rookie. It's written all over me — user8650741, Sep 21 '17 at 18:17

score 0 · Answer 1 · answered Sep 22 '17 at 00:09

i think SET clause should be after UPDATE clause then your JOIN. also you are trying to update column3 from table t2, the table t2 should be in the UPDATE clause since that is the one you will updating

UPDATE t2
   SET column3 = 'dte' 
 INNER JOIN t1
    ON t2.id = t1.id    
 WHERE t1.column = 456

How do I update a join query

1 Answers1