>Hi Vlad,
> You make an interesting observation about the # of queries apparently required with my SQL statement. I am not sure that the issue you mentioned applies to SQL however, as SQL is a non-procedural language. As I understand it, that means that the details of the implementation are determined at run time, and hidden from the developer. In general I would think that as long as the chosen SQL statement is one that was expected by the writers of the SQL implementation that the optimization process would find a sufficiently efficient way of processing the query, which would probably not match our logical model of how the query would be processed.
>
>P.S. Wasn't the initial question how to perform the query in one SQL statement?
I am not Vlad, but just to finish this discussion:
Select customer,max(date) as date,substr(max(dtoc(date,1)+allt(str(price))),9) as lastprice group by customer
So, this is one SQL combining my previous two (personally I prefer to break SQLs but if something can be broken, it might be combined by request).
Edward Pikman
Independent Consultant