Apply OS: Windows, Mac, Linux
Apply Navicat Product: Navicat for MySQL, Navicat for MariaDB, Navicat Premium
Apply Navicat Version No.: All
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