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?