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%')
select smallImage from tuan where id in(select fid from commend where smallTu not like '%57tuan%' or smallTu not like '%57tuan%')--应该是and吧? select smallImage from tuan where id in(select fid from commend where smallTu not like '%57tuan%' and smallTu not like '%57tuan%')
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%')
select smallImage from tuan where id in(select fid from commend where smallTu not like '%57tuan%' and smallTu not like '%57tuan%')