>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 works fine for me, I tried with this non-sensical (as those tables I used I had them open but are not related at all) query and it worked just fine
select delegateid, (select top 1 applicn from x:\fox\sky order by win_title) as Application from delegate
[Update]Arghh, forgot the where.... let me see...
[Update 2]Sorry Brandon, nothing to see here, I was wrong, as always....
"The five senses obstruct or deform the apprehension of reality."
Jorge L. Borges?
"Premature optimization is the root of all evil in programming."
Donald Knuth, repeating C. A. R. Hoare
"To die for a religion is easier than to live it absolutely"
Jorge L. Borges