select e.exp_number,e.exp_type,ec.claims_cost from express_tb e join exp_cost_tb ec on e.exp_number = ec.exp_number where ec.claims_cost is not null order by ec.claims_cost desc
简单
select e.exp_number,e.exp_type,ec.claims_cost from express_tb e join exp_cost_tb ec on e.exp_number = ec.exp_number where ec.claims_cost is not null order by ec.claims_cost desc
简单