Notes

SELECT * FROM (

SELECT PRODUCTS.*,PUNIUNIT,DPUNITDECIMAL,PROUVAL,PROUNAME,DPROKINDNAME,DCOLORNAME,CURVAL,CURNAME,PROSUPDAY,


((SELECT SUM(CASE WHEN PINVSTORID < 0 THEN PINVQUAN ELSE 0 END) TQUAN FROM PROINV
LEFT OUTER JOIN DEFSTORAGE ON DSTORID=PINVSTORID
WHERE DSTORCOMPANY='01' AND PINVYEAR=0 AND PINVMONTH=0 AND PROINV.PINVPROID = PRODUCTS.PROID ) -0 -
((SELECT ISNULL(SUM(ORDCHBALANCEQUAN),0) FROM ORDERSCHILD
LEFT OUTER JOIN ORDERS ON ORDID=ORDCHORDID
WHERE
ORDCHPROID=PRODUCTS.PROID
AND ORDSOURCE='1'
AND ORDCHID > 0
AND ORDCHBALANCEQUAN > 0
AND ORDCHCOMPANY='01' ))) AS SALEABLEQUAN


FROM PRODUCTS
LEFT OUTER JOIN PROUNIT ON PUNIPROID=PROID AND PUNISORT=0
LEFT OUTER JOIN DEFPROUNIT ON DPUNITVAL=PUNIUNIT
LEFT OUTER JOIN PRODUCTSUNITED ON PROUID=PROPROUID
LEFT OUTER JOIN DEFPRODUCTKIND ON DPROKINDVAL=PROKIND
LEFT OUTER JOIN DEFCOLOR ON DCOLORVAL=PROCOLORVAL
LEFT OUTER JOIN PROSUPPLIER ON PROSUPPROID=PROID AND PROSUPSORT=1
LEFT OUTER JOIN CURRENTS ON CURID=PROSUPCURID
WHERE PRODUCTS.PROPROUID = '1' AND PROSTS = 1 ) AS TT
WHERE TT.SALEABLEQUAN>0