SELECT a.*
FROM 主表 a
LEFT JOIN 码表 b ON a.RISK_LEVEL=b.VALUE and b.TYPE='risk_level'
LEFT JOIN 码表 c ON a.DEFINE_STATUS=c.VALUE and c.TYPE='define_status'
SELECT a.*
FROM 主表 a
LEFT JOIN 码表 b ON a.RISK_LEVEL=b.VALUE and b.TYPE='risk_level'
LEFT JOIN 码表 c ON a.DEFINE_STATUS=c.VALUE and c.TYPE='define_status'