How to query (sql) by listing the sports of the player doesn't belong to?

Question

sports table

players table

id	sport name
1	michael
2	stephen

player sports table

RESULT I WANT:

Michael (id: 1) should list the sports he doesn't belong to:

Stephen (id: 2) should list the sports he doesn't belong to:

This was the sql i did for Michael, but it return all data from playersports table including Stephen sports

SELECT * FROM `sports` LEFT JOIN `playersports` ON `sports`.id = `playersports`.sport_id WHERE `playersports`.`player_id` != 1;

I am not rude. I'm just pointing you at the existance of `EXISTS(...)` [and: `in(...)` is often inferior] — wildplasser, Mar 14 '22 at 01:20
You want this for every player or only one player at a time? — Salman A, Mar 15 '22 at 03:21

score 0 · Accepted Answer · answered Mar 13 '22 at 23:22

0

You can exclude all sort_ids which belog to player 1

SELECT s.id,s.name
FROM sports s WHERE s.id NOT IN ( SELECT sport_id FROM player_sports WHERE player_id  = 1)

answered Mar 13 '22 at 23:22

nbk

1 Answers1