Actually, the approach I used in the original example with an intermediate cursor is probably simpler that any scheme that does it all in one statement. I am simply trying to improve my understanding of SQL queries. Thanks - Joe
On Sunday, February 15, 2009 9:25 PM, Stephen Russell wrote: > >Date: Sun, 15 Feb 2009 20:25:00 -0600 >From: Stephen Russell >To: [email protected] >cc: >Subject: Re: Simplest form of SQL? > >On Sun, Feb 15, 2009 at 6:11 PM, Joe Yoder <[email protected]> wrote: >> When executed in VFP 9 SP2, Foxpro highlites the fourth line (SELECT * >> ;) and reports "Syntax error". I tried putting the code back into one >> line and other modifications based on my limited experience. I ended up >> with different errors but never got even an abbreviated version to >> complete. >> Joe >---------------------------------------- > >That sucks, I thought that VFP9 was up for that. Sorry. I thought >that Andy K. had shown that at the last VFP sig I went to. LA as I >remember. > >In ease of use you could just set up the full joins for version 1 and >union it to the same for 2. > >then run the total on memberID to drop down to a single row . > > > > > >-- >Stephen Russell >Sr. Production Systems Programmer >First Horizon Bank >Memphis TN > >901.246-0159 > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
