im dumb

sreya · sreya · commit 7ad3520fb243 · 2023-08-16T02:07:20.000Z
diff --git a/coderd/database/queries/groupmembers.sql b/coderd/database/queries/groupmembers.sql
@@ -3,13 +3,13 @@ SELECT
 	users.*
 FROM
 	users
-RIGHT JOIN
+LEFT JOIN
 	group_members
 ON
 	CASE WHEN @id:: uuid != @organization_id :: uuid THEN
 	group_members.user_id = users.id
 	END
-RIGHT JOIN
+LEFT JOIN
 	organization_members
 ON
     CASE WHEN @id :: uuid = @organization_id :: uuid THEN
