Thursday 15 August 2013

oracle - SQL 00918. 00000 - "column ambiguously defined" -


I have the "column ambiguously defined" error in "sql oracle code" and I do not understand that I have Why is the error? I know this means that code can not be used to find two columns of the same name, so I need to use the prefix but I have prefixes which are all correct. I saw other questions, but could not understand it.

ORA-00918: column int antideagment fixed number 00918. 00000 - "Columns fuzzy defined" * Reason:
* Action: line error: 4 column: 5

  SELECT KUND.KNR, KUND.FNAMN, KUND.ENAMN FROM KUND, ORDERRAD, KUNDORDER, KUNDORDER, ARTIKEL, VARUGRUPP WHERE KUND KNR = Condor KNR and Condor.OrdNR = Ordered. Order and OrderedRTNR = RTKL NTR and etiquel VGNR = Virugupur VGNR and Sancupur VGNAMN = 'Skaugwur' or Varagrup. VGNAM = 'Bondegaard';  

You are included twice in the condom table, so that you can help Have to use a nickname. Distinguish between them

But seeing that, most likely you want to join once in this table, and this is a typo.

On the one hand, as a note: You are using the inferred note to join the notation: FROM is better to use than tablename on table1 ON (...) Table 2 (...) - Join the annotation.

On the other hand, note that: This is a good practice to always use aliases for your tables to improve readability, for example: to Table 1 T1 JOIN TABLE 2 T2 ON (...)


No comments:

Post a Comment