67,513
社区成员
发帖
与我相关
我的任务
分享
select car.carton_no,car.carton_weight,car.update_time, nvl(count(box.packing_box_sys_id), 0) PACKED_BOX_NUM
from PACKING_BOX box, PACKING_CARTON car
where box.PACKING_CARTON_SYS_ID = car.PACKING_CARTON_SYS_ID
and car.CARTON_NO = 'CN0GH911708218CF02P7'
and box.STATUS = '1'
select car.carton_no,car.carton_weight,car.update_time, nvl(count(box.packing_box_sys_id), 0) PACKED_BOX_NUM
from PACKING_BOX box, PACKING_CARTON car
where box.PACKING_CARTON_SYS_ID = car.PACKING_CARTON_SYS_ID
and car.CARTON_NO = 'CN0GH911708218CF02P7'
and box.STATUS = '1'
group by car.carton_no,car.carton_weight,car.update_time;