Delete all highscores from a certain country

Question

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?

Answer 1

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);

Answer 2

To delete the records in tbl_highscores for all players with a specific playerCountry:

DELETE FROM tbl_highscores
WHERE playerId IN (
    SELECT playerId 
    FROM tbl_players
    WHERE playerCountry = 'lt')