select name,(select telephone from b where a.cid=b.id) from a where a.name like '%好%' 和 join 比起来 哪个刚好点？

select name，(select telephone from b where a . cid = b . id)from a where a . name like # 039；% good % # 039哪个比join好？select name，(select telephone from b where a . cid = b . id)from a where a . name like # 039；% good % # 039哪个比join好？简介: 解决方案:基本上没有太大区别