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@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.us

Received on Fri Jul 05 2002 - 13:06:57 CDT