Xref: alice comp.databases.oracle.misc:21800 Path: alice!news-feed.fnsi.net!news.idt.net!netnews.com!newspeer.monmouth.com!nntp.msen.com!news.altair.com!NewsNG.Chicago.Qual.Net!newsgate.mot.com!newshost.mot.com!schbbs.mot.com!not-for-mail From: "Alan D. Mills" Newsgroups: comp.databases.oracle.misc Subject: Re: Still having problems with report Date: Tue, 27 Oct 1998 13:20:49 -0000 Organization: Motorola Inc. Lines: 24 Message-ID: <714hac$ndd$1@schbbs.mot.com> References: <36347579.31827668@news.m.iinet.net.au> <71220l$bcm$1@schbbs.mot.com> <363583fd.17982719@news.m.iinet.net.au> X-Newsreader: Microsoft Outlook Express 4.72.2106.4 X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4 Remember, everything in your SELECT list which isn;t aggregated needs to be in the GROUP BY. You've only included the first two items. You also need to include s.conc_price and s.ord_price. Of course, you might then get what looks like duplicate records of s.film_no and fh.hire_price unless you include the extra GROUP BY columns at the start of your select list. That's anothte issue though... -- Alan D. Mills Oliver White wrote in message <363583fd.17982719@news.m.iinet.net.au>... >Having made the changes sugested I now get this error: > > (SUM(S.CONC_SEATS_SOLD) * S.CONC_PRICE) CONC_TAKINGS, > * >ERROR at line 2: >ORA-00979: not a GROUP BY expression > >This is the new code FYI >