Update values in table from another table in sql unable to understand what missing

Question

I came across situation where now I want to update the table but i want values which will come from another table. I have written fowllowing SQL , I am sure this is very foolish question , but this is last patterm which will complete my module and need to do this ASAP

UPDATE t 
SET t.col1 = o.col1, 
    t.col2 = o.col2
FROM 
    other_table o 

WHERE 
    o.sql = 'cool'

Possible duplicate of [Update a table using JOIN in SQL Server?](http://stackoverflow.com/questions/1604091/update-a-table-using-join-in-sql-server) — Ullas, Feb 08 '16 at 08:21

score 3 · Accepted Answer · answered Feb 08 '16 at 08:15

3

you missin join

UPDATE t 
SET t.col1 = o.col1, 
    t.col2 = o.col2
FROM 
    other_table o 
  JOIN 
    t ON t.id = o.id
WHERE 
    o.sql = 'cool'

answered Feb 08 '16 at 08:15

Pushkar Phule

160
11

1

@smit you was almost there , but you was just missing join there ..happy to help – Pushkar Phule Feb 08 '16 at 08:32

score 0 · Answer 2 · answered Feb 08 '16 at 08:16

0

You can try it using JOINS like

UPDATE t
SET
    t.col1 = o.col1, 
    t.col2 = o.col2
FROM
    t
INNER JOIN
    other_table o
ON t.id = o.id
WHERE 
    o.sql = 'cool'

answered Feb 08 '16 at 08:16

Rahul Tripathi

168,305
31
280
331

Update values in table from another table in sql unable to understand what missing

2 Answers2