查询产生费用的车辆
应收,实收 的保险费用
查询本月产生费用的车辆
应收,实收 的保险费用
应收,实收 的保险费用
select truck.ch ,
(select sum(bxfee) from fee where truck_id = truck.id and `type`='付' ) fbxf,
(select sum(bxfee) from fee where truck_id = truck.id and `type`='收' ) sbxf
from truck where id in (select distinct truck_id from fee)
查询本月产生费用的车辆
应收,实收 的保险费用
select truck.ch ,
(select sum(bxfee) from fee where truck_id = truck.id and `type`='付' ) fbxf,
(select sum(bxfee) from fee where truck_id = truck.id and `type`='收' ) sbxf
from truck where id in (select distinct truck_id from fee
where month(`date`) = ? )