题解 | 查询产生理赔费用的快递信息
select
et.exp_number,
exp_type,
claims_cost
from
express_tb et
join exp_cost_tb ect on et.exp_number = ect.exp_number
where
claims_cost is not null
order by
claims_cost desc
select
et.exp_number,
exp_type,
claims_cost
from
express_tb et
join exp_cost_tb ect on et.exp_number = ect.exp_number
where
claims_cost is not null
order by
claims_cost desc
相关推荐