mybatis中sql语句问题

select * from a where id in (select id from b);这样的sql在mybatis中要怎么写？

这要用到动态sql了，首先你要改成
<resultMap type="test" id="test">
<id property="id" column="id" />
<result column="name" property="name" />
<collection property="picture" ofType="picture">
<id property="picture_id" column="id" />
<result column="product_id" property="product_id" />
<result column="img" property="picture_img" />
</collection>
</resultMap>
<select id="selecTests" resultMap="test">
select
A.id ,
B.product_id,
B.img,
A.name
from test A
LEFT JOIN
picture B ON A.id=B.product_id
</select>
还有就是你的悬赏太少了

温馨提示：内容为网友见解，仅供参考

当前网址：https://11.t2y.org/zz/fs8smfsfpf47v88448m.html