Re: Still having problems with report

From: Alan D. Mills <alanmNOSPAM_at_uk.europe.mcd.mot.com>
Date: Tue, 27 Oct 1998 13:20:49 -0000
Message-ID: <714hac$ndd$1@schbbs.mot.com>

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_at_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
>
Received on Tue Oct 27 1998 - 07:20:49 CST