HI
i am using a script to join two tables together. i am getting the following error
ERROR at line 36:
ORA-00904: "A"."CUSTOMER_NO": invalid identifier
the script is as follows...
CREATE TABLE LEGACY_CIS.FIN_ADJS_ALL
as
SELECT
A.FIN_ADJS_KEY,
A.SERV_KEY,
A.SERVICE_NO,
A.CUSTOMER_NO,
A.ADJS_NO,
A.FIN_ADJS_DATE,
A.FIN_ADJS_TYPE,
A.FIN_ADJS_AMT,
A.VAT_ADJS,
A.DEP_TRANS_TYPE,
A.ACCOUNT_CODE,
A.WO_NUM,
A.ACCOUNT_LNK,
A.UNIT_LNK,
A.PROJECT_LNK,
A.CYCLE_NO,
B.TARIFF,
B.FIN_ADJS_REM,
B.AUTH_CODE,
B.DATE_OF_STAT,
B.CURRENTDATE,
B.CURRENT_TIME,
B.OPERATOR,
B.CHANGE_TYPE,
B.PROGRAM_NAME,
B.AUTHOR_ID,
B.AUTHOR_DATE
FROM FIN_ADJS A , FIN_ADJS_2 B
WHERE
A.FIN_ADJS_KEY=B.FIN_ADJS_KEY
AND A.SERV_KEY=B.SERV_KEY
AND A.SERVICE_NO=B.SERVICE_NO
AND A.CUSTOMER_NO=B.CUSTOMER_NO
AND A.ADJS_NO=B.ADJS_NO;
drop table FIN_ADJS;
drop table FIN_ADJS_2;
rename FIN_ADJS_ALL to FIN_ADJS;