mysql嵌套子查询

查询产生费用的车辆
应收，实收 的保险费用

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`) = ?  )