Hi Stephen, > why are you using the group by? Is it the sum of a column or > another aggregate?
Two situations, only the first is an aggregation. However the crux of the matter is the same in both, without this new requirement I can include fields I know to be non-variant across my group in the same query that produces my grouping to reduce the number of selections I need to perform. Regards Mark Stanton One small step for mankind... _______________________________________________ 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.
