SHARE
TWEET

Untitled

JulianoRoberto Feb 11th, 2019 62 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  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;
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!
 
Top