select a.lastname as 姓名,b.departmentname as 部门 from hrmresource a inner join hrmdepartment b where a.departmentid=b.id
泛微OA-内连接多表联查
于 2023-01-11 14:33:43 首次发布
select a.lastname as 姓名,b.departmentname as 部门 from hrmresource a inner join hrmdepartment b where a.departmentid=b.id