select smallImage from tuan where id in((select fid from commend where smallTu not like '%57tuan%')or(select sid from commend where smallTu not like '%57tuan%'))
...全文
2074打赏收藏
这样用in对嘛?为什么报错subquery returns more than 1 row在线等答案~~
select smallImage from tuan where id in((select fid from commend where smallTu not like '%57tuan%')or(select sid from commend where smallTu not like '%57tuan%'))
select
smallImage
from
tuan
where
id in (select fid from commend where smallTu not like '%57tuan%')
or
id in (select sid from commend where smallTu not like '%57tuan%')