主从表关联,判断子表全部符合条件后主有才有效

select *

from Pass_Head ph

left (

　　select distinct P_PASS_NO FROM

      PASS_HEAD WHERE STATUS!=7) ph2 on ph2.P_PASS_NO=ph.PASS_NO

WHERE ph2.P_PASS_NO IS NULL