print'找出Mike卖出的所有商品的商品名'
select wname
from ware
where wno in
(select wno
from s_w
where sno in
(select sno
from salesman
where sname='Mike'))


感觉这语句太复杂了，有没有其它语句能替代它的？