Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- UPDATE Materie_Prime
- SET Materie_Prime.qnt = Materie_Prime.qnt +(
- SELECT (Necessita.qnt * Riceve.qnt)
- FROM Ordine_C, Riceve, Necessita
- WHERE Riceve.codice_ord_c = OLD.codice_ord_c
- AND Riceve.codice_art = Necessita.codice_art
- AND Necessita.codice_mat = Materie_Prime.codice
- GROUP BY Materie_Prime.codice)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement