supervisor

mail@pastecode.io avatar
unknown
pgsql
3 years ago
725 B
1
Indexable
Never
select distinct
       staff_id,
       staff_name,
       personnel_id,
       email,
       position
from ms_staff
    join t_user_role
        on t_user_role.user_id = ms_staff.staff_id
where ms_staff.deleted_at is null
    and t_user_role.deleted_at is null
order by staff_name

// kalo ada school_level_id / school_location_id
select distinct
       staff_id,
       staff_name,
       personnel_id,
       email,
       position
from ms_staff
    join t_user_role
        on t_user_role.user_id = ms_staff.staff_id
where ms_staff.deleted_at is null
    and t_user_role.deleted_at is null
    and t_user_role.school_level_id = ??
    and t_user_role.school_location_id = ??
order by staff_name