Error ORA-00918
Plugin buscador de errores Nuevo!
Instala gratis el plugin para buscar errores de Oracle directamente desde la barra de tu navegador.
Descripción:
ORA-00918: columna definida de forma ambigua (column ambiguously defined)Causa:
Traducción automática de: A column name used in a join exists in more than one table and is thus referenced ambiguously. In a join, any column name that occurs in more than one of the tables must be prefixed by its table name when referenced. The column should be referenced as TABLE.COLUMN or TABLE_ALIAS.COLUMN. For example, if tables EMP and DEPT are being joined and both contain the column DEPTNO, then all references to DEPTNO should be prefixed with the table name, as in EMP.DEPTNO or E.DEPTNO.Acción:
Traducción automática de: Prefix references to column names that exist in multiple tables with either the table name or a table alias and a period (.), as in the examples above.COMENTARIOS:
por vifru | 09/11/2006 14:01:23
RE: ORA-00918
Agregando alias distintos a cada campo.
por Anónimo | 08/12/2006 4:15:00
RE: ORA-00918
puedes ser mas explicito???
por Anónimo | 23/07/2007 23:03:39
RE: ORA-00918
thanks.....i undestand everything....
nowadays it's working...
Gracias....entendi el problema.
Actualmente esta trabajando mi sw.
Plugin buscador de errores