General information
Category:
West Wind Web Connection
It's all in the mindset. I just spent about 20 minutes trying to figure out how I could structure a query, or set of queries to get information out of a table that wouldn't choke on version 8 syntax later. The problem was that I couldn't include a memo field in a group by clause, nor could I aggragate a memo field. The field I needed for a key into another table wasn't unique in this one. My mindset was on the new group by changes and I couldn't get away from it.
It was driving me nuts, so I got up and walked away from my desk to get a drink of water, and when I came back, I slapped myself upside the head, and used a Select distinct clause that works just fine.
Mindset. It's all in the mindset.
Alan
>>>>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