supervisor
unknown
pgsql
4 years ago
725 B
8
Indexable
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_nameEditor is loading...