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_brigade_info.sql
at main 10 lines 229 B view raw
kacaii.dev :art: lowercase all sql code
61f7a9ea
1-- 󰡦 Find details about a specific brigade 2select 3 b.id, 4 b.brigade_name, 5 u.id as leader_name, 6 b.is_active 7from public.brigade as b 8inner join public.user_account as u 9 on b.leader_id = u.id 10where b.id = $1;