DELETE/LIMIT problem

programming
1

I have a highscore table in MySQL. I want to delete all players below the 10’th place.
I thought this should do it, but I’m having problems:

DELETE FROM highScores WHERE ID = (SELECT ID FROM highScores ORDER BY score DESC LIMIT 10, 9999);

When I run the command I get this error:
[COLOR=“DarkRed”]#1093 - You can’t specify target table ‘highScores’ for update in FROM clause[/COLOR]

Can someone see the problem and tell me how the code should look?

Thanks guys.