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 / user / sql / query_crew_members.sql
at main 10 lines 310 B view raw
kacaii.dev :art: lowercase all sql code
61f7a9ea
1-- 󰢫 Retrieves detailed information about fellow brigade members 2-- for a given user, including their names and role details. 3select 4 u.id, 5 u.full_name, 6 u.user_role, 7 crew.brigade_id 8from public.query_crew_members($1) as crew 9inner join public.user_account as u 10 on crew.member_id = u.id;