SELECT supStat.*, supStat.supplierID, SUM(dr) dr, SUM(cr) cr, supp.*
FROM (`view_supplier_statement` supStat)
LEFT JOIN `supplier` supp ON `supp`.`ID`=`supStat`.`supplierID`
WHERE `supStat`.`companyID` =  '3'
GROUP BY `supStat`.`supplierID`