Advertisement
JulianoRoberto

Untitled

Feb 11th, 2019
82
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.26 KB | None | 0 0
  1. MERGE INTO APLICINSUMOAGRICTALHAO D
  2. USING
  3. (
  4. SELECT DISTINCT T.AREATOTAL, T.IDTALHAO
  5. FROM APLICINSUMOAGRICTALHAO AT
  6. INNER JOIN TALHAO T ON T.IDTALHAO = AT.IDTALHAO
  7. ) S
  8. ON(D.IDTALHAO = S.IDTALHAO)
  9. WHEN MATCHED THEN
  10. UPDATE SET AREAAPLIC = S.AREATOTAL;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement