http://sqlzoo.net/w/index.php?title=Ambigous_column_name&feed=atom&action=history
Ambigous column name - Revision history
2013-06-19T05:33:12Z
Revision history for this page on the wiki
MediaWiki 1.20.4
http://sqlzoo.net/w/index.php?title=Ambigous_column_name&diff=3374&oldid=prev
Andr3w at 13:17, 9 August 2012
2012-08-09T13:17:37Z
<p></p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;'>
<td colspan='2' style="background-color: white; color:black;">← Older revision</td>
<td colspan='2' style="background-color: white; color:black;">Revision as of 13:17, 9 August 2012</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 33:</td>
<td colspan="2" class="diff-lineno">Line 33:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><div class="ecomm e-access" style="display: none"></div></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><div class="ecomm e-access" style="display: none"></div></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></div></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></div></div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>[[Category<del class="diffchange diffchange-inline">|</del>Error]]</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>[[Category<ins class="diffchange diffchange-inline">:</ins>Error]]</div></td></tr>
</table>
Andr3w
http://sqlzoo.net/w/index.php?title=Ambigous_column_name&diff=3373&oldid=prev
Andr3w at 13:17, 9 August 2012
2012-08-09T13:17:00Z
<p></p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;'>
<td colspan='2' style="background-color: white; color:black;">← Older revision</td>
<td colspan='2' style="background-color: white; color:black;">Revision as of 13:17, 9 August 2012</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 33:</td>
<td colspan="2" class="diff-lineno">Line 33:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><div class="ecomm e-access" style="display: none"></div></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><div class="ecomm e-access" style="display: none"></div></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></div></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></div></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;">[[Category|Error]]</ins></div></td></tr>
</table>
Andr3w
http://sqlzoo.net/w/index.php?title=Ambigous_column_name&diff=1882&oldid=prev
Marek at 11:31, 19 July 2012
2012-07-19T11:31:09Z
<p></p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;'>
<td colspan='2' style="background-color: white; color:black;">← Older revision</td>
<td colspan='2' style="background-color: white; color:black;">Revision as of 11:31, 19 July 2012</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 1:</td>
<td colspan="2" class="diff-lineno">Line 1:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><div class='err'></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><div class='err'></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><div class=params>schema:gisq</div></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><div class=params>schema:gisq</div></div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><div class = "link e-oracle>ORA-00918: column ambiguously defined</div></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><div class = "link e-oracle<ins class="diffchange diffchange-inline">"</ins>>ORA-00918: column ambiguously defined</div></div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><div class = "link e-mysql>Error 1052</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><div class = "link e-mysql<ins class="diffchange diffchange-inline">"</ins>>Error 1052</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>Column 'name' in field list is ambiguous</div></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>Column 'name' in field list is ambiguous</div></div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><div class = "link e-sqlite>ambiguous column name:</div></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><div class = "link e-sqlite<ins class="diffchange diffchange-inline">"</ins>>ambiguous column name:</div></div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><div class = "link e-postgres>Error 7</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><div class = "link e-postgres<ins class="diffchange diffchange-inline">"</ins>>Error 7</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>ERROR: Column reference "name" is ambiguous</div></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>ERROR: Column reference "name" is ambiguous</div></div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><div class = "link e-db2>SQL0203N A reference to column "NAME" is ambiguous. SQLSTATE=42702 </div></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><div class = "link e-db2<ins class="diffchange diffchange-inline">"</ins>>SQL0203N A reference to column "NAME" is ambiguous. SQLSTATE=42702 </div></div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><div class = "link e-sqlserver>Msg 1013,</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><div class = "link e-sqlserver<ins class="diffchange diffchange-inline">"</ins>>Msg 1013,</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>Ambiguous column name 'name'.</div></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>Ambiguous column name 'name'.</div></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr>
</table>
Marek
http://sqlzoo.net/w/index.php?title=Ambigous_column_name&diff=1874&oldid=prev
Marek: Created page with "<div class='err'> <div class=params>schema:gisq</div> <div class = "link e-oracle>ORA-00918: column ambiguously defined</div> <div class = "link e-mysql>Error 1052 Column 'nam..."
2012-07-19T11:15:05Z
<p>Created page with "<div class='err'> <div class=params>schema:gisq</div> <div class = "link e-oracle>ORA-00918: column ambiguously defined</div> <div class = "link e-mysql>Error 1052 Column 'nam..."</p>
<p><b>New page</b></p><div><div class='err'><br />
<div class=params>schema:gisq</div><br />
<div class = "link e-oracle>ORA-00918: column ambiguously defined</div><br />
<div class = "link e-mysql>Error 1052<br />
Column 'name' in field list is ambiguous</div><br />
<div class = "link e-sqlite>ambiguous column name:</div><br />
<div class = "link e-postgres>Error 7<br />
ERROR: Column reference "name" is ambiguous</div><br />
<div class = "link e-db2>SQL0203N A reference to column "NAME" is ambiguous. SQLSTATE=42702 </div><br />
<div class = "link e-sqlserver>Msg 1013,<br />
Ambiguous column name 'name'.</div><br />
<br />
<div><br />
<h2>Problem</h2><p><br />
When more than one table is used (in a JOIN for example) there may be<br />
two columns with the same name.<br />
</p><p>In this example there is a column called <code>name</code><br />
in <code>bbc</code> and also in <code>cia</code>.<br />
</p><h2>Solutions</h2><ul><li>Include the table name before the column name:<br />
<pre>SELECT bbc.name<br />
FROM bbc JOIN cia ON bbc.name = cia.name<br />
</pre></li><li>Alias at least one of the tables and use that<pre>SELECT B.name<br />
FROM bbc B JOIN cia ON B.name = cia.name</pre></li></ul><br />
</div><br />
<br />
<source lang=sql class='tidy'></source><br />
<source lang=sql class='setup'></source><br />
<br />
<source lang='sql' class='def'>SELECT name<br />
FROM bbc JOIN cia ON bbc.name = cia.name<br />
</source><br />
<br />
<div class="ecomm e-access" style="display: none"></div><br />
</div></div>
Marek