Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Getting most recent orders?
Message
From
21/08/2007 16:16:53
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01249462
Message ID:
01249470
Views:
25
>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)
>
Pefrect, Sergey, thanks again. Now I have to figure out why I couldn't figure it out...
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform