users.sql

-- name: fetch-students-for-user
-- Returns all the students for this user

SELECT *
FROM users
WHERE id IN 
  (SELECT user_id FROM students WHERE flow_id IN 
    (SELECT id FROM flows WHERE owner_id = :user_id))

Wat vind je van deze:

SELECT *
FROM users
WHERE id IN
(SELECT DISTINCT user_id FROM students
LEFT JOIN flows ON flows.id = flow_id
WHERE owner_id = :user_id)