Re: CREATE VIEW fails, but works as just a SELECT

[Bob Field]

The problem is that some of your fields from different tables have the same name. Ideally you should list all of the fields explicitly, using aliases if you encounter duplication. Each of the tables in the join contains at least one field of the same name as in another table, as evident in your join conditions, so you don't have much choice. Also since it's an inner join, the fields are quite likely to contain redundant information anyway, so just eliminate the extra instances of the same column name will suffice.