1. EXCEL 将姓名置为一列,用CONCATENATE函数将查询的字段准备好。
2.数据库查询语句示例
select subcompanyid1 as 分部ID,lastname as 姓名,status, subcompanyname as 分部名称
from hrmresource a
join hrmsubcompany b
on a.subcompanyid1=b.id
where lastname in ('XXX','XXX')
and status <>5
3. 得到公司等相关信息线下处理
注意:重名现象