Steve,
There's only one table used in the query - 'mytable'. The 'mt1' and 'mt2' are aliases we assign to the table so we can use it in the main query and correlated subquery. It's similar to
USE mytable ALIAS mt1
USE mytable AGAIN ALIAS mt2
>I suspected that this was possible. Thanks. Do both of the tables mt1 and mt2 have
>to be created before hand? I think I have all of my data in what you would call mt1
>SELECT * FROM mytable mt1 ;
>WHERE price IN ( ;
>SELECT MAX(price) FROM mytable mt2 ;
>WHERE mt1.date = mt2.date) ;
>INTO CURSOR crsResult
--sb--