Исправьте ошибки в запросе и объясните, что он выполняет:
Код: Выделить всё
INSERT INTO TEMP_TABLE (CORP, HOUSE, CUST, CYCLE, UNIQUE_CUSTOMER_PIN, FIRST_NAME, LAST_NAME, PHONE_1,PHONE_2)
SELECT
WO.CORP,
WO.HOUSE,
WO.CUST,
CM.CYCLE,
CM.UNIQUE_CUSTOMER_PIN,
CM.FNAME,
CM.LNAME,
FROM WWWOOO WO
JOIN CCCMMM CM ON WO.CORP = CM.CORP AND WO.HOUSE = CM.HOUSE AND WO.CUST = CM.CUST
LEFT OUTER JOIN SSSDDD ON SD.RPT_COLL_WRITE_OFF_ID = WO.RPT_COLL_WRITE_OFF_ID
WHERE SD.RPT_COLL_WRITE_OFF_ID IS NULL
AND WO.ADD_DT > SYSDATE-10;