Delete all highscores from a certain country I have two tables:

tbl_players
tbl_highscores


I need to delete all highscores that are registered from a certain country. My problem is that the language are set per player, rather than by highscore. I can gather the information with JOIN like this:

SELECT scorePoints, playerAlias, playerEmail, playerCountry
    FROM tbl_highscores JOIN tbl_players ON tbl_highscores.playerId = tbl_players.playerId 
    WHERE playerCountry = 'lt' 


But how do I delete all highscores that are saved by a user from a certain language?
DELETE B.* FROM
(
    SELECT playerId FROM tbl_players 
    WHERE playerCountry = 'lt'
) A INNER JOIN tbl_highscores B
USING (playerId);


Make sure you have this index

ALTER TABLE tbl_players ADD INDEX CountryIDIndex (playerCountry,playerId);