Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- --------------------------------------------------------------------------------
- SELECT msuser.user_id AS id, +
- msuser.user_name AS username, +
- msuser.user_password AS password, +
- empun.unit_id AS id_poli, +
- employee_categories.empcat_id, +
- CASE +
- WHEN employee_categories.empcat_id = 17 THEN 1 +
- ELSE 2 +
- END AS aksesbener, +
- ms_unit.unit_name, +
- employee_categories.empcat_code, +
- employee_categories.empcat_name, +
- emp.employee_name +
- FROM ms_user msuser +
- LEFT JOIN employee emp ON msuser.employee_id = emp.employee_id +
- LEFT JOIN employee_on_unit empun ON emp.employee_id = empun.employee_id +
- JOIN employee_categories ON emp.empcat_id = employee_categories.empcat_id+
- JOIN ms_unit ON empun.unit_id = ms_unit.unit_id;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement