select
gs.id as goodsId
from table1 gs left join table2 wg on gs.id = wg.goods_id
where
( gs.id, wg.warehouse_id ) in (
<foreach item="item" index="index" collection="wgIdList" separator=",">
(#{item.goodsId},#{item.warehouseId})
</foreach>
)
group by gs.id,wg.warehouse_id
mybatis xml多字段in批量查询
最新推荐文章于 2024-04-27 10:26:13 发布