Hello all. How can I adjust the below statement to also only grab equipment.itemstatus='ACTIVE' items.
$getall="SELECT equipment.itemid, sum( receive.quantity ) AS 'receivedsum'
FROM equipment
LEFT JOIN receive ON equipment.itemid = receive.equipmentid
GROUP BY equipment.itemid
ORDER BY equipment.itemid ASC ";
