SELECT ra.Productcode, od.QtyOnHold, od.QtyShipped, od.ProductNote, od.OrderID, od.OrderDetailID, od.Warehouses, od.QtyOnPackingSlip
FROM products.receiving_archive ra
JOIN custopayted.orderdetails od ON od.OrderDetailID = ra.OrderDetailID
WHERE ra.ProductNote LIKE 'RET %' AND ra.TimeReceived >= CURDATE();