SELECT ra.*, od.ProductNote, od.Warehouses, od.QtyOnHold, od.QtyShipped, od.QtyOnPackingSlip, o.OrderStatus
FROM products.receiving_archive ra
JOIN custopayted.orderdetails od ON od.OrderDetailID = ra.OrderDetailID
JOIN custopayted.orders o ON o.OrderID = od.OrderID
WHERE ra.Shipped IS NULL;