$sql = "SELECT stockmaster.stockid,
stockmaster.description,
stockmaster.mbflag,
stockmaster.actualcost,
stockmaster.decimalplaces,
(stockmaster.materialcost + stockmaster.labourcost +
stockmaster.overheadcost ) as computedcost,
demandtotal.demand,
supplytotal.supply,
(demandtotal.demand - supplytotal.supply) *
(stockmaster.materialcost + stockmaster.labourcost +
stockmaster.overheadcost ) as extcost
FROM stockmaster
LEFT JOIN demandtotal ON stockmaster.stockid = demandtotal.part
LEFT JOIN supplytotal ON stockmaster.stockid = supplytotal.part
LEFT JOIN stockcategory ON stockmaster.categoryid = stockcategory.categoryid "
. $SQLCategory .
"WHERE stockcategory.stocktype<>'L'
GROUP BY stockmaster.stockid,
stockmaster.description,
stockmaster.mbflag,
stockmaster.actualcost,
stockmaster.decimalplaces,
stockmaster.materialcost,
stockmaster.labourcost,
stockmaster.overheadcost,
computedcost,
supplytotal.supply,
demandtotal.demand "
. $SQLHaving .
" ORDER BY '" . $_POST['Sort'] . "'";