>>>One other thing he's complaining about is VFP's supposed limitation on nested queries -- I guess levels past 2 aren't permitted?
>>>
>>>Do you know anything about this? For my part at least, I've never had to go past one level, and frankly have very seldom even had to do that.
>>
>>Jeff:
>>
>>Can you define "nested queries"?
>>
>>Tom
>
>Tom, my guess is something like:
>
>Select x from table1 where x in (select y from table2 where y in (select z from table3)))
>
>Alan

Alan;

That could well be the case. So you just use cascading select statements and build what you require. I have one that works on ten select statements with over 20 tables, until you get the data set desired. It is fast and does its job.

Tom