>>>Edward's answer was right, but there's a different syntax, which I prefer.
>>>
>>>SELECT * ;
>>> FROM mytable ;
>>> WHERE score IN (;
>>> SELECTscore;
>>> FROM mytable ;
>>> GROUP BY score ;
>>> HAVING COUNT(score) > 1)
>>>
>>>I believe this will work....
>>
>>Of course opinions may diverge, but isn't it simpler to use
>>
>>Select fieldA, Count(fieldA) As TotalRecs ;
>>From tableA ;
>>Group By fieldA ;
>>Having TotalRecs > 1
>>
>>?
>>
>>And besides, as my experience tells me, the simpler you SQL statements, the faster they get (although this isn't always true).
>>
>>Just an opinion...
>
>i guess it depends on whether or not you want a column in your result to hold the number of like scores...

You're right, I haven't thought about it.