SELECT
mab.fac_sn AS facSn,
mab.fac_name AS facName,
CASE mab.approve_sign
WHEN 0 THEN
'未认证'
WHEN 1 THEN
'已认证'
END,
mab.approved_time AS approvedTime
FROM
cn_member.member_approve_base mab
WHERE
1 = 1
AND mab.is_del = 'N'
转载于:https://my.oschina.net/u/655238/blog/1591778