Updating column values from one table to another

Question

I have three tables

X [id,event_time]
Y [x_id,z_id] -- here x_id is id from X and z_id is id from Z
Z [id,event_time]

Now I want to update the values of X[event_time] with Z[event_time]. Is there any query that can be formed for doing this?

Vivek S. · Accepted Answer · 2017-01-20 14:05:16Z

1

update x
set x.event_time = t.event_time
from (
    select z.event_time
        ,y.x_id
    from z
    join y on z.id = y.z_id
    ) t
where x.id = t.x_id

answered Jan 20, 2017 at 14:05

Vivek S.

22.3k9 gold badges71 silver badges87 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Chandan Rai · Accepted Answer · 2017-01-20 13:37:02Z

1

something like this

UPDATE X
SET event_time = z.event_time
FROM Z z
JOIN Y y ON y.z_id = z.id
JOIN X x ON y.x_id = x.id

answered Jan 20, 2017 at 13:37

Chandan Rai

10.5k2 gold badges22 silver badges29 bronze badges

Comments

Karan Shah · Accepted Answer · 2017-01-20 13:39:01Z

1

UPDATE X
SET event_id = (SELECT z.event_id FROM Z INNER JOIN Y WHERE Z.id=Y.z_id and Y.x_id=X.id)

answered Jan 20, 2017 at 13:39

Karan Shah

1,32411 silver badges15 bronze badges

Collectives™ on Stack Overflow

Updating column values from one table to another

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related