求助SQL优化，优化这个sql，求助

Question

 SELECT *
FROM ap_group_page agp
WHERE agp.compo_id IN
    (SELECT ad.compo_code
     FROM as_duty ad
     WHERE ad.duty_code IN
         (SELECT ard.duty_code
          FROM as_role_duty ard
          WHERE ard.role_id =
              (SELECT aer.role_id
               FROM as_emp_role aer
               WHERE aer.emp_code=
                   (SELECT ae.emp_code
                    FROM as_emp ae
                    WHERE ae.emp_code='liwh' ) )));

Answer 1

用join吧，不用总是用in
参考自：mysql join语法 http://www.data.5helpyou.com/article209.html