Query name, department, Post statement in the platform

--can be used when a person is multi-selected

SELECT b.ID,

B.user_name name,

D.dept_name Department,

D.dept_name | | ' {' | | | c.dept_name | | '} ' department posts,

D.DEPT_ID,

B.inp_code Input Code

From Sa_staff_info b

Left JOIN Sa_staff_role A

On a.user_id = b.ID

Left JOIN sa_dept_dict C

On c.dept_id = a.dept_id

Left JOIN sa_dept_dict D

On c.upper_id = d.dept_id

Order by D.dept_name, C.dept_name, B.user_name

Direct copy can see the actual effect, easy to understand. It is easy to grasp the structure of organization table.

Original address: http://bbs.delit.cn/thread-764-1-1.html

Reprint please indicate the source:

Author: metric Technology http://www.delit.cn

Query name, department, Post statement in the platform