Let's assume I have a select statement:
SELECT cname, ccity, cnumber sum(1) as groupcount from mytable group by
cname, ccity, cnumber orger by cname
I have to put all of the fields in the group by but the sum will give me
each individual cname, ccity, cnumber which is not what I want.
How do I get just the number of cnames?
VFP9 obviously.
--
Jeff
Jeff Johnson
[email protected]
SanDC, Inc.
(623) 582-0323
SMS (602) 717-5476
Fax 623-869-0675
www.san-dc.com
www.cremationtracker.com
www.agentrelationshipmanager.com
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.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.
