Jerry Wolper wrote: > > SELECT DISTINCT codeno, COUNT(codeno) FROM (SELECT DISTINCT > orderno+codeno, codeno FROM orders) > > This assumes that orderno and codeno are character fields; you can > figure out how to concatenate them otherwise.
Kudos to you for coming up with a correct answer first, but the judges must subtract 2 points because they (well, it's really just me) had to correct the code: SELECT code, COUNT(code) GROUP BY code FROM (SELECT DISTINCT order+code, code FROM codes) mycodes Thank you - TWO solutions. VFP rocks, SQL rocks! -- Vince Teachout Caracal Software www.caracal.net 518-733-9411 _______________________________________________ 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.
