代码如下:
SELECT ACCOUNT_NO AS baseAcctNo, 'CNY' AS ccy,
(CASE
WHEN CHECK_STATUS = '0' AND REPORT_CHECK = '0' THEN '03'
WHEN CHECK_STATUS IN ('2', '4') AND REPORT_CHECK = '0' THEN '02'
WHEN CHECK_STATUS = '1' AND REPORT_CHECK = '1' THEN '01'
END) AS asFlag,
CHECK_REPORT_DATE AS asDate
FROM T_ACCOUNT_INFO