SELECT od.DeliveryNo, od.ReceiptNo, c.Name AS Contact,
c.Street + ' ' + c.City + ' ' + c.Zip AS Address,
c.TIN, od.DateAdded, od.SONo AS PurchaseNo,
odd.Quantity, i.Name, i.Description
FROM Orders_Deliveries od
LEFT JOIN Orders o ON o.SONo = od.SONo
INNER JOIN Orders_Deliveries_Details odd ON od.DeliveryNo = odd.DeliveryNo
INNER JOIN Customers c ON o.CustomerID = c.CustomerID
INNER JOIN Items i ON odd.ItemID = i.ItemID
WHERE od.DeliveryNo={?DeliveryNo}