leedonet

Oracle Partition by Parse Error

14

SELECT * FROM SUB_DATA_CUST1 A LEFT JOIN SELECT * FROM SUB_DATA_CUST2 A WHERE A.STD_YM BETWEEN TO_CHAR (ADD_MONTHS (SYSDATE,-15), 'YYYYMM') AND TO_CHAR (SYSDATE,'yyyymm') ) B PARTITION BY ( B.COMP_CD, B.CUST_CD, B.STD_YM,...