Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Need Help with SQL Statement
Message
From
20/09/1997 01:03:33
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00050724
Message ID:
00050883
Views:
50
>
>George, isn't this exactly the reason Ed used two SELECT statements?
>
>Barbara


I pointed out earlier you don' t need two statements. I think the original question was how to do it with one SELECT.

Hope this helps.

SELECT * FROM Quotes WHERE ;
DTOC(Date)+Customer IN ;
(SELECT MAX(DTOC(Date))+Customer FROM Quotes)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform