SELECT VPAP.PERSONNUM
,PCD.PERSONCSTMDATATXT
FROM VP_ALLPERSONV42 VPAP
LEFT JOIN PERSONCSTMDATA PCD
ON (VPAP.PERSONID= PCD.PERSONID
AND PCD.CUSTOMDATADEFID=
(select CUSTOMDATADEFID from CUSTOMDATADEF where SHORTNM=N'工作属性') )
WHERE PERSONNUM='20000000077'
Kronos获取自定义信息
最新推荐文章于 2024-08-29 08:39:10 发布