--三张表:人员表、岗位表、部门表,人员表中的 departmentid = HrmDepartment.ID ,jobtitle = hrmjobtitles.ID;
select departmentid AS '所属部门',loginid ,jobtitle,hrmjobtitles.id As'岗位ID' ,HrmDepartment.id AS'部门ID'
from hrmresource ,hrmjobtitles,HrmDepartment
--三张表:人员表、岗位表、部门表,人员表中的 departmentid = HrmDepartment.ID ,jobtitle = hrmjobtitles.ID;
select departmentid AS '所属部门',loginid ,jobtitle,hrmjobtitles.id As'岗位ID' ,HrmDepartment.id AS'部门ID'
from hrmresource ,hrmjobtitles,HrmDepartment