Cache1116

select ttt.updated_date, ttt.plan_code, ttt.risk_level, ttt.treaty_no, ttt.indemnity_limit_type, ttt.indemnity_limit, (ttt.risk_class_code)风险等级代码, ttt.id_rims_treaty_prop_section from rims_treaty_prop_coverage_t ttt where ttt.updated_date >= sysdate -1 and ttt.plan_code = 'B01' union

select * from rims_treaty_prop_risk_info_t