kacaii.dev / senac-brigade-server
wip: currently rewriting the project as a full stack application tangled.org/kacaii.dev/sigo
gleam
fork atom
senac-brigade-server / src / app / domain / brigade / sql / query_members_info.sql
at main 9 lines 212 B view raw
kacaii.dev :art: lowercase all sql code
61f7a9ea
1--  Find all members of a brigade 2select 3 u.id, 4 u.full_name, 5 u.user_role 6from public.user_account as u 7inner join public.brigade_membership as bm 8 on u.id = bm.user_id 9where bm.brigade_id = $1;