Skip to Main Content

Need help in sql

e9c1784e-76cf-4460-aa2c-3c6d2aac947dAug 9 2018 — edited Aug 10 2018

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..

Immagine.png

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked due to inactivity on Sep 7 2018
Added on Aug 9 2018
5 comments
111 views