SELECT TOP 100 PERCENT dbo.Customers.Company, MAX(dbo.Orders.ShipDate) AS Expr1,
(SELECT dbo.OrderItems.Price FROM dbo.OrderItems) AS Expr2
FROM dbo.Customers INNER JOIN
dbo.Orders ON dbo.Customers.CustomerID = dbo.Orders.CustomerID INNER JOIN
dbo.OrderItems ON dbo.Orders.OrderID = dbo.OrderItems.OrderID
WHERE (dbo.Orders.Deleted = 0)
GROUP BY dbo.OrderItems.InvMasID, dbo.Customers.Company