>SELECT Customer.CustomerID, Customer.CustName, Orders.OrderID, ; > Orders.OrderDate, Orders.Destination ; > FROM Customer ; > INNER JOIN orders ON Orders.CustomerID = Customer.CustomerID ; > WHERE OrderDate = ( SELECT MAX(OrderDate) FROM Orders o2 WHERE o2.CustomerID = Orders.CustomerID) >Hi Sergey,
SELECT Customer.CustomerID, Customer.CustName, Orders.OrderID, ; Orders.OrderDate, Orders.Destination ; FROM Customer ; INNER JOIN orders ON Orders.CustomerID = Customer.CustomerID ; Inner JOIN (select Max(OrderDate) as Max_Date, CustomerID from Orders group by CustomerID) MaxOrders ; on Orders.CustomerID = MaxOrders.CustomerID and ; Orders.OrderDate = MaxOrders.Max_Date