select
T.*,
P.PRSN_NAME,
CASE WHEN P.PRSN_SEX =1 THEN '先生' WHEN P.PRSN_SEX =0 THEN '女士'
ELSE NULL END AS PRSN_SEX
from
MWMS.dbo.MWMS_VW_CORP_RECFEE AS T
LEFT JOIN
MWMS.dbo.MWMS_PERSON P ON T.CORP_ID=P.CORP_ID
数据2005
最新推荐文章于 2020-08-18 16:32:04 发布