SELECT a.ITEMCOD, b.ITEMNAM, a.CUSTCOD, a.LOSSGUB, b.thsyear, b.yearqty,
SUM(DECODE(b.THSyear,'1', b.yearqty, 0)) QTY1,
SUM(DECODE(b.THSyear,'2', b.yearqty, 0)) QTY2,
SUM(DECODE(b.THSyear,'3', b.yearqty, 0)) QTY3,
SUM(DECODE(b.THSyear,'4', b.yearqty, 0)) QTY4,
SUM(DECODE(b.THSyear,'5', b.yearqty, 0)) QTY5,
SUM(DECODE(b.THSyear,'6', b.yearqty, 0)) QTY6,
SUM(DECODE(b.THSyear,'7', b.yearqty, 0)) QTY7,
SUM(DECODE(b.THSyear,'8', b.yearqty, 0)) QTY8,
SUM(DECODE(b.THSyear,'9', b.yearqty, 0)) QTY9,
SUM(DECODE(b.THSyear,'10', b.yearqty, 0)) QTY10,
SUM(DECODE(b.THSyear,'11', b.yearqty, 0)) QTY11,
SUM(DECODE(b.THSyear,'12', b.yearqty, 0)) QTY12,
FROM P3041T a, B1080T b
where a.coporat = b.coporat
GROUP BY a.ITEMCOD, b.ITEMNAM, a.CUSTCOD, a.LOSSGUB
ORDER BY a.thsyear asc
이게 제가 짜본 쿼리인데 계속 missing keyword 하면서 안되네요 ㅠ
general sql error ora-00936 이러면서,, ㅠㅠ 뭐가 뭔지.. 쿼리 분석좀 부탁드립니다~ |