From 0b520dc2529d7df6263842480d4ba7eaf07f4dcd Mon Sep 17 00:00:00 2001 From: nsfisis Date: Sat, 10 Aug 2024 14:06:28 +0900 Subject: feat(backend): include `players` in `Game` object --- backend/query.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'backend/query.sql') diff --git a/backend/query.sql b/backend/query.sql index 13bbbe6..12b67b9 100644 --- a/backend/query.sql +++ b/backend/query.sql @@ -58,7 +58,7 @@ LIMIT 1; -- name: ListGamePlayers :many SELECT * FROM game_players -LEFT JOIN users ON game_players.user_id = users.user_id +JOIN users ON game_players.user_id = users.user_id WHERE game_players.game_id = $1 ORDER BY game_players.user_id; -- cgit v1.2.3-70-g09d2