Advertisement
Guest User

Untitled

a guest
Jul 30th, 2015
157
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.44 KB | None | 0 0
  1. update TableX x
  2. set x.A= x.A +
  3. (select y.A
  4. from TableY y
  5. where x.id= y.id)
  6. where exists (select y.id
  7. from TableY y
  8. where x.id = Y.id).
  9.  
  10. update TableX x
  11. set (x.A, x.B, x.C) = (select y.A + x.A,
  12. y.B + x.B,
  13. y.C + x.C
  14. from TableY y
  15. where x.id= y.id)
  16. where exists (
  17. select y.id
  18. from TableY y
  19. where x.id = Y.id)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement