Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- update TableX x
- set x.A= x.A +
- (select y.A
- from TableY y
- where x.id= y.id)
- where exists (select y.id
- from TableY y
- where x.id = Y.id).
- update TableX x
- set (x.A, x.B, x.C) = (select y.A + x.A,
- y.B + x.B,
- y.C + x.C
- from TableY y
- where x.id= y.id)
- where exists (
- select y.id
- from TableY y
- where x.id = Y.id)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement