This is a little hard to explain, but I need to get a count of distinct codes within orders. For example:
Order 1: code1 Code 1 code 1 code 2 code 3 Order 2: code 1 Code 3 I'd like to see: "Code 1", 2 "Code 2", 1 "Code 3, 2 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. -- 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.
