SELECT * ,
CASE SEX
WHEN 1 THEN '男'
WHEN '0' THEN '女'
END AS SEXNM ,
( SELECT NAME
FROM SYS_DATADICT
WHERE PCODE = 'PARTY'
AND CODE = a.PARTY
) PARTYNM ,
AD_DCWC
FROM WR_WRR_INF_M a
LEFT JOIN WR_AD_B b ON a.REC_CD = b.AD_CD
在oracle数据库里面总是报错。。。

来人帮忙啊

End后面as不用一个空格就行了

On后面要加（）

SELECT a.* ,
CASE SEX
WHEN '1' THEN '男'
WHEN '0' THEN '女'
ELSE ''
END AS SEXNM ,
( SELECT NAME
FROM SYS_DATADICT
WHERE PCODE = 'PARTY'
AND CODE = a.PARTY
) PARTYNM ,
AD_DCWC
FROM WR_WRR_INF_M a
LEFT JOIN WR_AD_B b ON a.REC_CD = b.AD_CD