Re: ORA-00979: not a GROUP BY expression??
From: Jason Baugher <jason_at_baugher.pike.il.us>
Date: Fri, 05 Jul 2002 18:06:57 GMT
Message-ID: <Xns9242856B6548Cjasonbaugherpikeilus_at_209.242.76.10>
>
> Your query is so ugly that I can't really get into it for lack of
> time.
Date: Fri, 05 Jul 2002 18:06:57 GMT
Message-ID: <Xns9242856B6548Cjasonbaugherpikeilus_at_209.242.76.10>
Daniel Morgan <dmorgan_at_exesolutions.com> wrote in news:3D25C240.9E406E63_at_exesolutions.com:
> Smithesh Kollara wrote:
>> SELECT
<snip long nasty query body>
>> ,CustomerGroup, Truckno,ReceiptKey,SKU,COrigin,CargoType, RefNo
>
> Your query is so ugly that I can't really get into it for lack of
> time.
It's ugly all right - reminds me of some of the SQL from Oracle's upgrade scripts in Apps 11i. :)
-- Jason Baugher Virtual Adept Professional Consulting Services 1406 Adams St. Quincy, IL 62301 (217) 221-5406 http://baugher.pike.il.us/virtualadept jason_at_baugher.pike.il.usReceived on Fri Jul 05 2002 - 20:06:57 CEST