Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Is VFP SQL ansi compliant ?
Well....the arycsh table should have in some cases more than one matching record per record in the temp table. So record 1, 2 and 3 in arycsh might match record 1 in temp. But when I remove the aggregate functions to see the results of the query that for records 2 and 3 in the arycsh table there...- glengarth
- Post #5
- Forum: Microsoft: FoxPro
-
Is VFP SQL ansi compliant ?
...as to the grouping, I have found what appears to be the same results when I include the field arycsh.custno in the group clause. And I need that field to join the 2 tables. Yes, the inner join would be better; I've tried it since the original post. No better, or so it seems.- glengarth
- Post #3
- Forum: Microsoft: FoxPro
-
Is VFP SQL ansi compliant ?
I'm doing data analysis of some customer data in a bunch of VFP 5.0 free tables (no actual database container); they're used in an accounting package I won't mention (but's it's initials are SBT). I'm doing an inner join which should produce some very straight-forward results. Here's the...- glengarth
- Thread
- Replies: 5
- Forum: Microsoft: FoxPro
