SELECT
m.personnelid
FROM
yorgpersonnel m
WHERE
m.organizationid='SAP_ZHUXJ20120409091538000007'--查询某部门的所有成员
AND EXISTS
(
SELECT
1
FROM
ypersonnel a
WHERE
m.personnelid=a.personnelid
AND a.userid!='e2c4bfa637af48ceaa98dd59d48b432d')--这句会过滤使用的这条记录