SELECT o.orderid, o.orderstatus, od.productnote, od.qtyonhold, od.qtyshipped, od.qtyonpackingslip 
FROM orders o
JOIN orderdetails od ON o.orderid = od.orderid AND od.productcode NOT LIKE '%DSC-%'
WHERE o.orderstatus = 'Shipped'
AND od.qtyonhold > 0
AND od.productnote LIKE '%STOCK%'