Re: SQL Blues......Part 2 HELP!!!

From: jAnO! <j.j.groot_at_kpn.com>
Date: 2000/07/06
Message-ID: <8k27ce$267$1_at_hdxl22.telecom.ptt.nl>#1/1


[Quoted] mAd hAcker <madhackerboy_at_hotmail.com> wrote in message news:4s095.1881$87.4703_at_news1.mts.net...
> Okay, I tried that.....but I keep getting an error -
> "ORA-00979: not a GROUP BY expression"
> Why isn't it a GROUP BY expression?

I'm not sure but i think it has something to do with te fact that you're also selecting columns that have specific data thats different for multiple rows.
[Quoted] [Quoted] Maybe you should trie to select at first only player_name and max_point make that one work and gradualy make your query larger..

greetz

Jan
(taking OCP exam 1 next week..) Received on Thu Jul 06 2000 - 00:00:00 CEST

Original text of this message