Hello there. This query seems to double quantities when printed to screen. I can't figure out why. Please help🙁
$equiplist="select receive.equipment, sum(receive.quantity) as 'receivedsum', sum(shiplist.quantity) as 'shippedsum'
from receive
left join shiplist on shiplist.equipment = receive.equipment
group by receive.equipment";
