> This is a little hard to explain, but I need to get a count of distinct > codes within orders. For example: > > [snip] > > ie, distinct within orders, but then a count of codes for all orders. > Anyway to do it in one shot? I'm pretty sure I can do it in 2 queries. > Thanks.
Something like 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. -Jerry Wolper [EMAIL PROTECTED] _______________________________________________ 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.
