supervisor
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