MERGE INTO MDM_PSN M
            USING (SELECT EMPLOYEENO,        --职工编号
                          EMPNAME,           --姓名
                          GENDER,            --性别
                          BIRTHDAY,          --出行日期
                          IDCARD_NO,         --身份证号
                          ORG_CODE,          --单位代码
                          ORG_NAME,          --单位名称
                          COMM_CODE,         --社区代码
                          MAR_STATUS_CODE,   --婚姻状况代码
                          RESI_TYPE_CODE,    --户口类别代码
                          EMP_TYPE_CODE,     --职工类别代码
                          EMP_TYPE,          --职工类别
                          ISSOLVE,           --是否协解
                          ISRETIRE,          --是否内退
                          EMP_ATTR_CODE,     --职工性质代码
                          ISEMPDEAL,         --是否享受职工待遇
                          CHARGE_RATE FROM FC_PSN) F      --收费比率
                          ON(M.FC_PSN_ID=F.EMPLOYEENO OR( NVL(M.FC_PSN_ID,M.NAME_CH)=F.EMPNAME AND
                                                           NVL(M.FC_PSN_ID,M.SEX)=F.GENDER  AND
                                                           NVL(M.FC_PSN_ID,M.BIRTHDATE)=F.BIRTHDAY AND
                                                           NVL(M.FC_PSN_ID,M.IDCARD)=F.IDCARD_NO
                                                         )
                              )
说是M.FC_PSN_ID  (invalid identifier无效标识符)可是我的mdm_psn 中明明有这个例啊,我在PLSQL中(.点)的时候也能点出来啊
mdm_psn 列如下
ID VARCHAR2(100) N
HR_PSN_ID VARCHAR2(50) Y 人力唯一标识
SB_PSN_ID VARCHAR2(50) Y 社保表唯一标识
FC_PSN_ID VARCHAR2(50) Y 房产表唯一标识
CJ_ID VARCHAR2(50) Y 采集表唯一标识
NAME_CH VARCHAR2(20) Y 个人信息--姓名中文
NAME_ENG VARCHAR2(80) Y 个人信息--姓名英文
SEX VARCHAR2(2) Y 个人信息--性别