>VFP won't let you do this
>
>
>SELECT table1.pk1,
> (select top 1 somecharfield from table2 where pk1=table1.pk1 order by pk2) as somecharfield
> from table1
>
>
>You get error message: Queries of this type are not supported
>
>
>Of course I can cheat with a prequery, but what's your best work around for this VFP limitation?
It's not clear to me what you're trying to do. Your subquery is not in a WHERE clause? Can you show us the whole statement?
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up