如何在外连接的表里加过滤条件

Question

select * 
from a,b
where a.col=b.col(+)
and b.col(+)=...

Answer 1

SELECT Flightcd, Aircarrier, c.NAME
  FROM Flightmst f,
       (SELECT Fliaghtcd, NAME
          FROM Custquotationairfreight
         WHERE Isrole = '1') c
 WHERE f.Flightcd = c.Fliaghtcd(+)
;

Answer 2

select flightcd,aircarrier,name from 
flightmst a,CUSTQUOTATIONAIRFREIGHT b
where a.flightcd=b.FliAghtCD(+) and b.isrole=1;

Answer 3

select flightcd,aircarrier,name from 
flightmst a,CUSTQUOTATIONAIRFREIGHT b
where a.flightcd=b.FliAghtCD(+) and b.isrole(+)=1;