SELECT co140c.itmnm, ib010d.itm, ib010d.qty, ib010d.net, ib030s.iqty, ib030s.iamt,
ib010d.qty - NVL(ib030s.iqty, 0) AS sqty , ib010d.net - NVL(ib030s.iamt, 0) AS samt
FROM ib010m, ib010d, ib030s, co140c
WHERE ib010m.ino = ib010d.ino
AND co140c.itm = ib010d.itm
AND ib010m.iodt BETWEEN:as_yymm ||'01' AND :as_yymm ||'31'
AND ib030s.itm(+) = ib010d.itm
AND ib030s.ym(+) = :as_yymm
이 문장을 유니온으로 2개의 쿼리로 나눌수있을까요 아우터조인걸린 기준으로요!
궁금한점댓글달아주세요