select distinct
a.box_number,
a.inner_box_label ,
a.material_number,
a.supplier_name,
a.production_batch,
a.inner_box_quantity
,a.box_quantity ,
a.real_quantity real_quantity,
truncate_string(a.specifications, 32) AS specifications
,truncate_string(a.product_name, 32) AS product_name
from e2yun_delivery_label_innerbox a , e2yun_delivery_label b
where a.deleted =0 and b.deleted =0
and a.delivery_line_id = ${id} and b.id in (${DaoFormat.in('${labeIds}')}) and a.box_number =b.box_number
1.6.2版本之后in需要使用函数
参考文档:JeecgBoot 文档中心