Inspectopedia
 
2024.3

Ambiguous reference

Warning
New
Last modified: 03 December 2024

Reports columns that have identical names but belong to different tables.

Example (MySQL):

The id column appears in foo and bar tables. You need to qualify the column name to make the query correct.

SELECT foo.id, bar.id FROM foo, bar WHERE foo.id > 0;