Re: sql aggregate question

Myron Wintonyk <mwintony_at_med.ualberta.ca> wrote in <3A663A39.F777BDCC_at_med.ualberta.ca>:

>select team, name, score from players A
> where score = ( select max( score)
> from players B
> where A.PLAYER = B.PLAYER
> and A.TEAM = B.TEAM );
>

Even after I changed your line

   where A.PLAYER = B.PLAYER
to

   where A.NAME = B.NAME (there's no field named player) it still doesn't work for me.
That sql produces a list of all the names, not just the top scorers.

• doug edmunds 17 Jan 2001