diff options
Diffstat (limited to 'query/users.sql')
| -rw-r--r-- | query/users.sql | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/query/users.sql b/query/users.sql index d136f15..2528513 100644 --- a/query/users.sql +++ b/query/users.sql @@ -46,3 +46,8 @@ RETURNING *; UPDATE users SET is_deleted = true WHERE id = ? AND is_deleted = false; + +-- name: GetUserNetworks :many +SELECT networks.* FROM networks +JOIN users_networks ON networks.id = users_networks.network_id +WHERE users_networks.user_id = ?; |