Advertisement
Guest User

Untitled

a guest
Jun 18th, 2019
71
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.08 KB | None | 0 0
  1. A [ID, column1, column2, column3]
  2. B [ID, column1, column2, column3, column4]
  3.  
  4. C [ID, column1, column2,column3]
  5.  
  6. UPDATE C
  7. set column1=t.firstTab, column2=t.secondTab, column3=t.thirdTab
  8. from (select A.column1 as firstTab, B.column2 as secTab,
  9. (A.column1 + B.column2) thirdTab
  10. from A, B limit 1; ) as t ;
  11.  
  12. UPDATE 0
  13.  
  14. select A.column1 as firstTab, B.column2 as secTab, (A.column1 + B.column2) thirdTab
  15. from A, B limit 1;
  16.  
  17. UPDATE C
  18. SET column1 = A.column1
  19. , column2 = B.column2
  20. , column3 = A.column1 + B.column2
  21. FROM A
  22. JOIN B ON A.id = B.id -- ??? not specified in question!
  23. WHERE C.id = A.id -- ??? not specified in question!
  24. AND (C.column1, C.column2, C.column3) IS DISTINCT FROM
  25. (A.column1, B.column2, A.column1 + B.column2);
  26.  
  27. UPDATE C
  28. set column1=t.firstTab, column2=t.secondTab, column3=t.thirdTab
  29. from (select A.column1 as firstTab, B.column2 as secTab,
  30. (A.column1 + B.column2) thirdTab
  31. from A
  32. join B on ...
  33. where ... ) as t
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement