|
Home > Archive > FoxPro Help and Support > January 2006 > Help w/SQL
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
|
| I have executed the following SQL code on numerous occasions in VFP6 with no
problems, however, now that we upgraded to 9.0, Fox tells me my group by
clause is now invalid not matter what variables I choose for the group by
statement. Any suggestions?
SELECT lookup_regions.name,
final_disclosure. naics,final_disclosu
re. disc2,final_disclosu
re.region;
FROM final_disclosure inner join lookup_regions;
on final_disclosure.region = lookup_regions.region;
WHERE final_disclosure.disc2 = "N";
GROUP BY final_disclosure.naics,
final_disclosure. region,final_disclos
ure.disc2;
ORDER BY final_disclosure.region,
final_disclosure. naics,final_disclosu
re.disc2;
into table final_suppress
| |
| Cindy Winegarden 2006-01-04, 3:24 am |
| Hi DL,
Please see Fred's and my posts replying to yours in the Chatter newsgroup.
Posting the same question separate times to different newsgroups means the
discussions are fragmented and people may spend time preparing a response to
a question that's already been answered sufficiently.
Most of us who read here look at all the groups so there's little need to
post to more than one group.
--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy_winegarden@msn
.com www.cindywinegarden.com
"DL" <DL@discussions.microsoft.com> wrote in message
news:8343D96A-3A24-4BB5-A89F- 6493FA2E2974@microso
ft.com...
>I have executed the following SQL code ......
|
|
|
|
|