General information
Category:
West Wind Web Connection
>>>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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only