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_all_brigades.sql
at main 9 lines 210 B view raw
kacaii.dev :art: lowercase all sql code
61f7a9ea
1-- 󱉯 Find all registered brigades 2select 3 b.id, 4 b.brigade_name, 5 u.full_name as leader_name, 6 b.is_active 7from public.brigade as b 8left join public.user_account as u 9 on b.leader_id = u.id;