Advertisement
Guest User

Untitled

a guest
Jun 26th, 2019
81
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.62 KB | None | 0 0
  1. UPDATE Artigos
  2. SET totale = entradas.sent
  3. FROM Artigos INNER JOIN (SELECT cod_artigo, Sum([quantidade_ent]) AS sent FROM entradas GROUP BY cod_artigo)
  4. ON Artigos.cod_artigo = Entradas.cod_artigo;
  5.  
  6. UPDATE Artigos
  7. SET Artigos.totale = tmp.sent
  8. FROM Artigos INNER JOIN (SELECT cod_artigo, Sum([quantidade_ent]) AS sent FROM entradas GROUP BY cod_artigo) as tmp
  9. ON Artigos.cod_artigo = tmp.cod_artigo;
  10.  
  11. UPDATE artigos
  12. SET totale = tmp.sent
  13. FROM (SELECT cod_artigo,
  14. SUM(quantidade_ent) AS sent
  15. FROM entradas
  16. GROUP BY cod_artigo
  17. )
  18. tmp
  19. WHERE tmp.cod_artigo = tmp.cod_artigo;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement