Workfine | 用SQL语句写视图的方法#20220428

[password key=1110]

视频文件

文件编号：Workfine用SQL语句写视图的方法#20220428

代码

SELECT  A.id AS 用户ID, A.user_name AS 姓名, A.login_name AS 登录名, A.mobile AS 手机号, A.is_active AS 是否停用, 
                   C.id AS 部门ID,C.dept_name AS 部门名称,C.dept_full_name AS 部门全称, C.full_path AS 部门ID全称, C.seq AS 排序seq
FROM      dbo.tb_sys_user AS A INNER JOIN
                   dbo.tb_sys_user_org AS B ON A.id = B.user_id INNER JOIN
                   dbo.tb_sys_dept AS C ON B.dept_id = C.id

SELECT * FROM tb_sys_user  --用户表
SELECT * FROM tb_sys_user_org--用户部门表
SELECT * FROM tb_sys_dept--部门表

文末

[/password]