select ......
from ...,ra,ha
where......
and (ra.parentregionid=14 and ra.id=ha.regionid)
or (ha.regionid=ra.id and ra.parentregionid=rb.id and rb.parentregionid=14));
和
select ......
from ...,ra,ha
where......
and ha.regionid in (select id from region where parentregionid=14)
or ha.regionid in (select id from region where parentregionid in (select id from region where parentregionid=14));
的结果为什么不同啊?
郁闷的很。
求教达人
from ...,ra,ha
where......
and (ra.parentregionid=14 and ra.id=ha.regionid)
or (ha.regionid=ra.id and ra.parentregionid=rb.id and rb.parentregionid=14));
和
select ......
from ...,ra,ha
where......
and ha.regionid in (select id from region where parentregionid=14)
or ha.regionid in (select id from region where parentregionid in (select id from region where parentregionid=14));
的结果为什么不同啊?
郁闷的很。
求教达人
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货