Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- MERGE INTO APLICINSUMOAGRICTALHAO D
- USING
- (
- SELECT DISTINCT T.AREATOTAL, T.IDTALHAO
- FROM APLICINSUMOAGRICTALHAO AT
- INNER JOIN TALHAO T ON T.IDTALHAO = AT.IDTALHAO
- ) S
- ON(D.IDTALHAO = S.IDTALHAO)
- WHEN MATCHED THEN
- UPDATE SET AREAAPLIC = S.AREATOTAL;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement