1-- Find the id of all members assigned a specific brigade 2select u.id 3from public.user_account as u 4inner join public.brigade_membership as bm 5 on u.id = bm.user_id 6where bm.brigade_id = $1;