diff options
Diffstat (limited to 'query/members.sql')
| -rw-r--r-- | query/members.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/query/members.sql b/query/members.sql index 65d3600..3d20b01 100644 --- a/query/members.sql +++ b/query/members.sql @@ -10,10 +10,10 @@ WHERE network_id = ? AND is_member = true; SELECT * FROM members WHERE network_id = ? AND user_id = ?; --- name: GetNetworksOfUser :many +-- name: GetUserNetworks :many SELECT networks.* FROM networks JOIN members ON networks.id = members.network_id -WHERE members.user_id = ?; +WHERE members.user_id = ? AND members.is_member = true; -- name: SetMember :one INSERT INTO members ( |