General information
Category:
Coding, syntax & commands
>
>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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only