[Sample] Left outer join 비교

SELECT c.REQ
     , a.CD
     , a.NM     
     , b.VAL
     , a.TYP
     , a.DIV
FROM   TB_ATTB_MST a
LEFT OUTER JOIN TB_ATTB b ON a.CD = b.ID AND  b.NO = '1321313810199'
LEFT OUTER JOIN TB_MST  c ON b.NO = c.NO AND c.NO = '1321313810199'
where TYP = 02'
;
 
SELECT b.REQ
     , a.CD
     , a.NM     
     , b.VAL
     , a.TYP
     , a.DIV
FROM   TB_ATTB_MST a
,TB_ATTB b
WHERE  a.CD = b.ID(+)
AND a.TYP = 02'
AND b.REQ(+) = '1321313810199'