>Try
>

>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,

This select will return the same result (VFP9 only). I'm wondering which one is better?

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