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