请高手帮忙,看看这个UPDATA怎样解决
UPDATE TESTMDM M SET ( M.FC_PSN_ID, M.FC01,M.FC02,M.FC04,M.FC05,M.FC06,M.FC08,M.FC09,M.FC12,
M.FC13,M.FC17,M.FC18,M.FC19,M.FC20,M.FC21,M.FC22,M.FC23,
M.FC24,M.DATASOURCE_FROM)=(SELECT F.EMPLOYEENO,F.EMPLOYEENO,
F.EMPNAME,F.GENDER,F.BIRTHDAY,
F.IDCARD_NO,F.ORG_CODE,F.ORG_NAME,
F.RESI_TYPE_CODE,F.MAR_STATUS_CODE,
F.EMP_TYPE,F.EMP_TYPE_CODE,F.ISSOLVE,
F.ISRETIRE,F.EMP_ATTR_CODE,F.ISEMPDEAL,
F.CHARGE_RATE,F.COMM_CODE,'FC'
FROM FC_PSN F WHERE IS_MORE IS NULL
AND F.EMPNAME=M.NAME_CH
AND DECODE(F.GENDER,'男','1','女','2')=M.SEX
AND F.BIRTHDAY=M.BIRTHDATE
AND F.IDCARD_NO=M.IDCARD AND M.ROWS_MORE IS NULL AND M.FC_PSN_ID IS NULL)
WHERE M.FC_PSN_ID IS NULL;
中间的select 语句的WHERE 条件怎么写在最外层啊也就是说我想写成这样的
UPDATE TESTMDM M SET ( M.FC_PSN_ID, M.FC01,M.FC02,M.FC04,M.FC05,M.FC06,M.FC08,M.FC09,M.FC12,
M.FC13,M.FC17,M.FC18,M.FC19,M.FC20,M.FC21,M.FC22,M.FC23,
M.FC24,M.DATASOURCE_FROM)=(SELECT F.EMPLOYEENO,F.EMPLOYEENO,
F.EMPNAME,F.GENDER,F.BIRTHDAY,
F.IDCARD_NO,F.ORG_CODE,F.ORG_NAME,
F.RESI_TYPE_CODE,F.MAR_STATUS_CODE,
F.EMP_TYPE,F.EMP_TYPE_CODE,F.ISSOLVE,
F.ISRETIRE,F.EMP_ATTR_CODE,F.ISEMPDEAL,
F.CHARGE_RATE,F.COMM_CODE,'FC'
FROM FC_PSN F WHERE IS_MORE IS NULL )
WHERE F.EMPNAME=M.NAME_CH AND DECODE(F.GENDER,'男','1','女','2')=M.SEX
AND F.BIRTHDAY=M.BIRTHDATE
AND F.IDCARD_NO=M.IDCARD AND M.ROWS_MORE IS NULL AND M.FC_PSN_ID IS NULL
这样的怎么实现啊,如果这样写在外层的话这里的这个别名F怎样处理啊