该博客详细解析了ADPM_MIGRATE_CPAMASTER表中的人员迁移情况，包括迁出区域、操作时间、迁移状态和转入区域。通过与ADPM_REGION_CODE表的关联，展示了选择的地区名称，特别关注了状态为10、20和60的迁移记录。
SELECT 1 UPLOAD,
0 SHENGJI,
MR。BUSI_ID,
MASTER。PERSON_ID,
MASTER。ACNT_ID,
MASTER。ID_NUM,
MASTER。NAME,
MASTER。SEX,
MR。
MIGRT_OUT_REGION,
MR。OUT_OPERA_TIME,
MR。OUT_OPERA_ID,
MR。IN_OPERA_TIME,
MR。MIGRATE_STATE,
MR。MIGRT_IN_REGION,
case
when MR。
MIGRT_IN_REGION is null then
'未选择'
else
ARC。REGION_NAME
end AS MIGRT_IN_REGION_NAME
FROM ADPM_MIGRATE_CPA MASTER, ADPM_MIGRATE_INFO MR
left join ADPM_REGION_CODE ARC on MR。
MIGRT_IN_REGION = ARC。REGION_CODE
WHERE MASTER。PERSON_ID = MR。PERSON_ID
AND (MR。MIGRATE_STATE = '10' OR MR。MIGRATE_STATE = '20' OR
MR。
MIGRATE_STATE = '60');
SELECT 1 UPLOAD,
0 SHENGJI,
MR。BUSI_ID,
MASTER。PERSON_ID,
MASTER。ACNT_ID,
MASTER。ID_NUM,
MASTER。
NAME,
MASTER。SEX,
MR。MIGRT_OUT_REGION,
MR。OUT_OPERA_TIME,
MR。OUT_OPERA_ID,
MR。IN_OPERA_TIME,
MR。MIGRATE_STATE,
MR。
MIGRT_IN_REGION,
case
when MR。MIGRT_IN_REGION is null then
'未选择'
else
ARC。REGION_NAME
end AS MIGRT_IN_REGION_NAME
FROM ADPM_MIGRATE_CPA MASTER, ADPM_MIGRATE_INFO MR, ADPM_REGION_CODE ARC
WHERE MASTER。
PERSON_ID = MR。PERSON_ID
AND (MR。MIGRATE_STATE = '10' OR MR。MIGRATE_STATE = '20' OR
MR。MIGRATE_STATE = '60')
AND MR。MIGRT_IN_REGION = ARC。
REGION_CODE(+);。
全部
4681
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
