SELECT SUM(V.QUANTITA) - SUM(F.QUANTITA)
FROM E_FORNITO F, E_VENDUTO V
WHERE F.COD_PROD='369872' AND V.COD_PROD='369872'
Hi all, I have a problem with this query, doesn't return the actual number of quantities of the product with code 369872 despite having verified the correct data entered.
The correct result is 512 but prints a negative number. Please help me..