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

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.
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 CDT