Difference between revisions of "Ambigous column name"
From SQLZOO
| Line 33: | Line 33: | ||
<div class="ecomm e-access" style="display: none"></div> | <div class="ecomm e-access" style="display: none"></div> | ||
</div> | </div> | ||
| − | [[Category | + | [[Category:Error]] |
Latest revision as of 13:17, 9 August 2012
schema:gisq
ORA-00918: column ambiguously defined
Error 1052
Column 'name' in field list is ambiguous
ambiguous column name:
Error 7
ERROR: Column reference "name" is ambiguous
SQL0203N A reference to column "NAME" is ambiguous. SQLSTATE=42702
Msg 1013,
Ambiguous column name 'name'.
Problem
When more than one table is used (in a JOIN for example) there may be two columns with the same name.
In this example there is a column called name
in bbc and also in cia.
Solutions
- Include the table name before the column name:
SELECT bbc.name FROM bbc JOIN cia ON bbc.name = cia.name
- Alias at least one of the tables and use that
SELECT B.name FROM bbc B JOIN cia ON B.name = cia.name
SELECT name FROM bbc JOIN cia ON bbc.name = cia.name
