Not having problems with report

Thanks for your help mate, see you next semester in all likelyhood :)

On Tue, 27 Oct 1998 13:20:49 -0000, "Alan D. Mills" <alanmNOSPAM_at_uk.europe.mcd.mot.com> wrote:

#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
#>
#
#
#

--
On the smeeter.
MHM 22x9
-- Received on Tue Oct 27 1998 - 22:31:16 CST