I have two tables:
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?