Duplicate column names in SQL query
13,779
Solution 1
Using alias for column name
CREATE VIEW db.VI_RegionCity AS SELECT
Region.Name as Region_name,
City.Name as City_name
...//rest of the query
Solution 2
CREATE VIEW db.VI_RegionCity AS SELECT
Region.Name AS RegionName,
City.Name AS CityName
FROM
db.Region Region,
db.City City
WHERE
Region.RegionCode = City.RegionCode
Author by
enfield
Updated on June 13, 2022Comments
-
enfield almost 2 years
How do I avoid a dup column name error in MySQL when creating a VIEW on two tables that both have the same column name as shown here
CREATE VIEW db.VI_RegionCity AS SELECT Region.Name, City.Name FROM db.Region Region, db.City City WHERE Region.RegionCode = City.RegionCode ERROR: Duplicate column name 'Name'