I have a problem in my query...
The query does not sum all the (qty)...even it have a value it outputs "0" value.
Heres the query:
SELECT `tblinventory`.`PK` AS `PK`,
`tblinventory`.`prdct_ID` AS `ProductID`,
`tblinventory`.`prdct_upc_barcode` AS `UPCBarcode`,
`tblinventory`.`prdct_supp_ID` AS `SupplierID`,
`tblinventory`.`prdct_supp` AS `SupplierName`,
`tblinventory`.`prdct_ctgry_ID` AS `CategoryID`,
`tblinventory`.`prdct_ctgry` AS `CategoryName`,
`tblinventory`.`prdct_name` AS `ProductName`,
`tblinventory`.`prdct_desc` AS `ProductDesc`,
`tblinventory`.`lot` AS `ProductLot`,
`tblinventory`.`unitcost` AS `UnitCost`,
`tblinventory`.`packaging` AS `Package`,
`tblinventory`.`exprtion_date` AS `Expiration`,
`tblinventory`.`min_stck_level` AS `MinStckLvl`,
`tblinventory`.`prdct_srp` AS `SRP`,
`tblinventory`.`prdct_retail_price` AS `RP`,
`tblinventory`.`qty` AS `QTY`,
IFNULL((SELECT SUM(tblwarehouse_prodcts.prod_qty) FROM tblwarehouse_prodcts WHERE (tblwarehouse_prodcts.prod_id=tblinventory.prdct_ID)),0) as W_Entry,
IFNULL((SELECT SUM(tblreplacement_prodcts.prod_qty) FROM tblreplacement_prodcts WHERE (tblreplacement_prodcts.prod_id=tblinventory.prdct_ID)),0) as W_Rplcmnt,
IFNULL((SELECT SUM(tbladjustment_prodcts.prod_qty) FROM tbladjustment_prodcts WHERE (tbladjustment_prodcts.prod_id=tblinventory.prdct_ID)),0) as W_Adjstmnt,
IFNULL((SELECT SUM(tbloutgoing_prodcts.prod_qty) FROM tbloutgoing_prodcts WHERE (tbloutgoing_prodcts.prod_id=tblinventory.prdct_ID)),0) as W_OTStck,
ifnull((
(SELECT SUM(tblwarehouse_prodcts.prod_qty) FROM tblwarehouse_prodcts WHERE (tblwarehouse_prodcts.prod_id=tblinventory.prdct_ID)) + (SELECT SUM(tblreplacement_prodcts.prod_qty) FROM tblreplacement_prodcts WHERE (tblreplacement_prodcts.prod_id=tblinventory.prdct_ID)) -
(SELECT SUM(tbladjustment_prodcts.prod_qty) FROM tbladjustment_prodcts WHERE (tbladjustment_prodcts.prod_id=tblinventory.prdct_ID)) - (SELECT SUM(tbloutgoing_prodcts.prod_qty) FROM tbloutgoing_prodcts WHERE (tbloutgoing_prodcts.prod_id=tblinventory.prdct_ID)
)),0) AS TOTALQTY
from tblinventory
GROUP BY prdct_ID
....can anyone help me?