SELECT  orderdetails.OrderDetailID, orderdetails.ProductNote, orderdetails.OrderID, orders.orderstatus, orderdetails.Quantity, orderdetails.QtyOnHold, orderdetails.QtyShipped, orderdetails.QtyOnPackingSlip, orderdetails.Vendor_Price, orderdetails.ProductPrice, orderdetails.TotalPrice
FROM orderdetails
JOIN orders ON orderdetails.OrderID = orders.OrderID 
JOIN trackingnumbers ON orders.OrderID = trackingnumbers.OrderID
WHERE orders.orderstatus NOT IN ('Shipped','Cancelled') 
AND orders.OrderID < 8120283
AND orderdetails.QtyOnHold <> 0 
AND ProductCode NOT LIKE 'DSC%'