PO-131210-RM-01 | 1 | 9 | 1 |
PO-131210-RM-01 | 2 | 10 | 2 |
PO-131210-RM-01 | 3 | 18 | 0 |
PO-131210-RM-01 | 1 | AAA | 9 | 1 |
PO-131210-RM-01 | 2 | BBB | 3 | 1 |
PO-131210-RM-01 | 2 | CCC | 7 | 1 |
PO-131210-RM-01 | 3 | DDD | 18 | 0 |
PO-131210-RM-01 | 1 | 9 | 1 | AAA | 9 | 1 |
PO-131210-RM-01 | 2 | 10 | 2 | BBB | 3 | 1 |
PO-131210-RM-01 | 2 | 10 | 2 | CCC | 7 | 1 |
PO-131210-RM-01 | 3 | 18 | 0 | DDD | 18 | 0 |
PO-131210-RM-01 | 1 | 9 | 1 | AAA | 9 | 1 |
PO-131210-RM-01 | 2 | 10 | 2 | BBB | 3 | 1 |
CCC | 7 | 1 | ||||
PO-131210-RM-01 | 3 | 18 | 0 | DDD | 18 | 0 |
WITH MA170MP(maqpono, maqposeq,maqhqty,maqbqty ) AS ( SELECT 'PO-131210-RM-01' ,1 ,9 ,1 FROM DUAL UNION ALL SELECT 'PO-131210-RM-01' ,2 ,10 ,2 FROM DUAL UNION ALL SELECT 'PO-131210-RM-01' ,3 ,18 ,0 FROM DUAL ), MA180MP (MARPONO ,MARPOSEQ ,marhtno, marhqty, marbqty ) AS ( SELECT 'PO-131210-RM-01','1','AAA',9 ,1 FROM DUAL UNION ALL SELECT 'PO-131210-RM-01','2','BBB',3 ,1 FROM DUAL UNION ALL SELECT 'PO-131210-RM-01','2','CCC',7 ,1 FROM DUAL UNION ALL SELECT 'PO-131210-RM-01','3','DDD',18, 0 FROM DUAL ) SELECT DECODE(RN,1,maqpono ) maqpono , DECODE(RN,1,maqposeq ) maqposeq , DECODE(RN,1,maqhqty ) maqhqty , DECODE(RN,1,maqbqty ) maqbqty , marhtno, marhqty, marbqty FROM (SELECT maqpono, maqposeq,maqhqty,maqbqty,marhtno, marhqty, marbqty , ROW_NUMBER() OVER(PARTITION BY maqpono, maqposeq,maqhqty,maqbqty ORDER BY NULL) RN FROM MA170MP LEFT OUTER JOIN MA180MP ON MAQPONO=MARPONO AND MAQPOSEQ = MARPOSEQ )
네 답변 갑사 드립니다 마농님
http://www.gurubee.net/lecture/1021 에서 참고 했는데 제가 잘못 이해했네요
DISTINCT 부분 있었네요.
감사 드립니다.