General information
Category:
Coding, syntax & commands
>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)
Yes, but you still have two SQL-SELECTs (even if one is embeded). Still, yours should be faster than 2 separate SELECTs.
Vlad
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