Android Question SQL table

manuelsalazar said:

I forgot that also in TYPE field have also the Letter 'C' and also Letter 'D', so those records don't have to SUM or REST.

Thanks in advanced






Si

Click to expand...

SELECT  Product ,

        SUM(CASE WHEN Type = 'P' THEN Quantity

                 WHEN Type = 'N' THEN Quantity * -1

                 ELSE 0

            END) AS Quantity

FROM    tblProducts

GROUP BY Product;

Alex_197 said:

If I understood you correctly - I would do this

B4X:

SELECT  Product ,
        SUM(CASE WHEN Type = 'P' THEN Quantity
                 ELSE Quantity * -1
            END) AS Quantity
FROM    tblProducts
GROUP BY Product;

Product Quantity
PRODUCT-A 4
PRODUCT-B 7

Click to expand...