Im trying to make list of all genres (game_genre), make checkboxes from those and check boxes if any is in (mail_genre). Im having problem when there are multiple users. SQL is making me problems.
SELECT
*
FROM game_genre AS gg
LEFT JOIN mail_genre AS mg
ON mg.genre_id = gg.id
id genre genre_id user_id
1 Strategy 1 3
2 RPG 2 1
2 RPG 2 3
3 Other NULL NULL
