Difference between revisions of "Ambigous column name"

From SQLZOO
Jump to: navigation, search
 
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|Error]]
+
[[Category:Error]]

Latest revision as of 14:17, 9 August 2012

schema:gisq

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
Personal tools
Namespaces

Variants
Actions
Reference
Toolbox
Google AdSense