How to Solve the “Ambiguous Name Column” Error in SQL
Give the tables an alias
Published in
2 min readOct 5, 2020
At times you may want to join two tables in SQL and there are in the tables, columns with the same name.
In this case, if you join the two tables and run the query without differentiating the names of the columns that are the same, the error “Ambiguous name column” will glare at you.