高手请进--->>>解决SELECT语句
SELECT officecode FROM devproout.ala_lawoffice WHERE officecode IN(
SELECT p.officecode FROM devproout.ala_person p,devproout.ala_lawoffice l WHERE p.officecode =l.officecode(+) AND chief='2' GROUP BY p.officecode HAVING COUNT(*)<3
) OR officecode IN(
SELECT p.officecode FROM devproout.ala_lawpartner p,devproout.ala_lawoffice l WHERE p.officecode=l.officecode(+) AND l.chief<>'2' AND l.form<>4 GROUP BY p.officecode HAVING COUNT(*)<3
) OR officecode IN(
SELECT p.officecode FROM devproout.ala_person p,devproout.ala_lawoffice l WHERE p.officecode =l.officecode(+) AND p.persontype='1' AND form=4 GROUP BY p.officecode HAVING COUNT(*)<3
)
从这个SELECT语句,我要得到各个条件的officecode.
从而在父表中查询数据,就用了 officecode IN() OR office IN ()。但是子查询速度非常慢。
我的想法是,用一条SELECT语句写跟佳。从而避免数组相加。
请高手解决该SELECT。使之提高速度。