SELECT od.OrderID, ProductID, CompanyName
FROM Orders AS o
JOIN order_details AS od
ON o.OrderID=od.OrderID
JOIN Shippers AS s
ON o.ShipVia=s.ShipperID
JOIN Products AS p
ON od.ProductID=p.ProductID;