>>I have a table where I have a numeric field with scores stored in them. I
>>would like to select all the records with similar scores into a temp table in
>>order to resolve other things.. I have tried select *,count(*)as tie from
>>mytable group by tie > 1. But I cannot get it to list everyone. How can I
>>do this?
>
>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....
Yes! This syntax nicely combines two Select commands into one.
Edward Pikman
Independent Consultant