需要字段项为登录名、姓名、手机、部门、角色、所属仓库
select u.login_name, u.user_name, u.mobile_no, role.role_name, w.wh_name,o.org_name from com_user u, com_role role, tb_usc_org o, com_role_user ru, tb_usc_warehouse w, tb_usc_warehouse_user wu where u.user_id = ru.user_id and ru.role_id = role.role_id and u.user_id = wu.user_id and wu.wh_id = w.wh_id and u.office_id = o.org_id order by 2
欢迎光临 临海小憇 (http://www.czidea.cn/) | Powered by Discuz! X3.3 |