Apply OS: Windows, Mac, Linux

Apply Navicat Product: Navicat for MySQL, Navicat for MariaDB, Navicat Premium

Apply Navicat Version No.: All


Solution

Please note that views must have unique column names with no duplicates. By default, the names of the columns retrieved by the SELECT statement are used for the view column names.

As your tables in SELECT statement contain some column names which are the same, therefore it results in violation and throws an error. You may consider to define explicit names for the view columns using Alias.

For more information, please refer to MySQL manual - http://dev.mysql.com/doc/refman/5.0/en/create-view.html

Have more questions?
Submit Ticket