|

楼主 |
发表于 2017-11-22 11:14:50
|
显示全部楼层
select SA_OPOrg,SA_OPOrg.sName as sName,SA_OPOrg.sCode as sCode,SA_OPOrg.sFName as sFName,SA_OPOrg.sFID as sFID,replace(SA_OPOrg.sPhone, substring(SA_OPOrg.sPhone, 4, 4), '****') as sPhone,SA_OPOrg.sPersonID as sPersonID,SA_OPPerson.sSex as sSex,(null) as nearstDept
from SA_OPOrg SA_OPOrg
optional join SA_OPPerson SA_OPPerson on SA_OPOrg.sPersonID = SA_OPPerson
where SA_OPOrg.sValidState = 1 AND SA_OPOrg.sOrgKindID = 'psm' |
|