select tb_out_detail.od_no as od_no,
tb_out_detail.od_name as od_name,
sum(tb_out_detail.od_num_out) as od_num_out,
tb_out,tb_out.ot_info as ot_info
from tb_out_detail tb_out_detail
optional join tb_out tb_out on tb_out = tb_out_detail.od_master_id
where tb_out.ot_info ='已提交'
group by tb_out_detail.od_name, tb_out_detail.od_no