14 Nov 00 9:27
I've made an append-query which appends selected data of a table located on an Oracle database to a an Access-table. I made the query in MSAccess and made an ODBC-link to the ORACLE-table. The ORACLE-table is called EKET and the Access-table is called Pre-EKET. The records I want to select are records for which the key is also present in the Access-table Pre-EKPO. So there's a link between the Oracle-Table and the Access-table. The strange thing is that I have executed already several queries like this and it worked without any problems. For this query however I get following error:
[ORACLE][ODBC ORACLE DRIVER][ORACLE OCI]ORA-00960: ambiguous column naming in select list (#960)
Can somebody help me with this one, it really drives me crazy. I tried everything: renaming the columns, changing the type, etc...
The sql-statement is the following:
INSERT INTO [Pre-EKET] ( EBELN, EBELP, ETENR )
SELECT DISTINCTROW [Pre-EKPO].EBELN, [Pre-EKPO].EBELP, SAPR3_EKET.ETENR
FROM SAPR3_EKET INNER JOIN [Pre-EKPO] ON (SAPR3_EKET.EBELP =
[Pre-EKPO].EBELP) AND (SAPR3_EKET.EBELN = [Pre-EKPO].EBELN);
All help is really welcome. Thank you very much in advance!