SELECT
CYD.DEPT_NAME,
T . ID,
T .CODE,
T . NAME,
T . JOB,
CASE WHEN(T.SEX=0) THEN '男' WHEN(T.SEX=1) THEN '女' ELSE 'X' END AS SEX,
T .BIRTH,
T .POL_STA,
T .NAT_PLA,
T .STA_DATE,
T .END_DATE,
T .DEPT_CODE,
T .PHONE,
T .TELE_PHONE,
T .EMAIL,
T .ADDRESS
FROM
EDIIS_DEPT_LEADER T
LEFT JOIN PLATFORM.C_SYS_DEPT CYD ON T .DEPT_CODE = CYD.CODE
查询性别的时候格式化
最新推荐文章于 2022-10-01 09:33:00 发布