SELECT od.orderdetailid, od.orderid, od.productcode, od.productname, od.quantity, od.qtyshipped, od.qtyonhold, od.qtyonpackingslip, od.shipdate, od.lastmodified, od.productcode, od.productnote, od.qtyonbackorder, od.qtyonhold, od.qtyshipped, od.lastmodby, o.vol_oid
FROM orderdetails od
JOIN orders o on o.orderid = od.orderid
WHERE od.quantity <> od.qtyshipped + od.qtyonhold
AND od.orderid > 6000000