Assuming you have a column on nsidetails[\I] that designates items as "shipped", just add a where clause as follows:
SELECT equipment.itemid, sum( receive.quantity ) AS 'receivedsum', sum( nsidetails.quantity ) AS 'shippedsum'
FROM equipment
LEFT JOIN receive ON equipment.itemid = receive.equipmentid
LEFT JOIN nsidetails ON equipment.itemid = nsidetails.equipmentid
WHERE nsidetails.shipped_column = 'shipped_value'[\B]
GROUP BY equipment.itemid
If you tell an item is shipped by it's quantity being > 0 then you can use the HAVING clause
SELECT equipment.itemid, sum( receive.quantity ) AS 'receivedsum', sum( nsidetails.quantity ) AS 'shippedsum'
FROM equipment
LEFT JOIN receive ON equipment.itemid = receive.equipmentid
LEFT JOIN nsidetails ON equipment.itemid = nsidetails.equipmentid
GROUP BY equipment.itemid
HAVING shippedsum > 0[\B]
Also, I don't think you can use an ORDER BY clause with a GROUP BY clause. They are somewhat redundant. GROUP BY requires a sort and returns the result set in ascending order.
T
