Advertisement
Guest User

Untitled

a guest
Apr 24th, 2019
105
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.48 KB | None | 0 0
  1. --------------------------------------------------------------------------------
  2. SELECT msuser.user_id AS id, +
  3. msuser.user_name AS username, +
  4. msuser.user_password AS password, +
  5. empun.unit_id AS id_poli, +
  6. employee_categories.empcat_id, +
  7. CASE +
  8. WHEN employee_categories.empcat_id = 17 THEN 1 +
  9. ELSE 2 +
  10. END AS aksesbener, +
  11. ms_unit.unit_name, +
  12. employee_categories.empcat_code, +
  13. employee_categories.empcat_name, +
  14. emp.employee_name +
  15. FROM ms_user msuser +
  16. LEFT JOIN employee emp ON msuser.employee_id = emp.employee_id +
  17. LEFT JOIN employee_on_unit empun ON emp.employee_id = empun.employee_id +
  18. JOIN employee_categories ON emp.empcat_id = employee_categories.empcat_id+
  19. JOIN ms_unit ON empun.unit_id = ms_unit.unit_id;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement