Ambiguous column in SELECT could not be resolved

  • Article

This error occurs when any database object definition or deployment script contains a SELECT statement that refers to a column that has the same name as another column in a table or view. If you create such a statement, the reference cannot be resolved. You must disambiguate the reference by providing additional qualification to it. For example, you must add the name of the table that contains the appropriate column. If tables in multiple schemas have the same name, you must also specify the name of the schema that contains the appropriate table.

To correct this error

  1. Double-click the error message in the Error List window to open the Transact-SQL (T-SQL) editor.

  2. Qualify the reference by adding the name of the table that contains the column. If tables with the same name exist in multiple schemas, also specify the name of the schema.

See Also

Tasks

How to: Modify Database Objects
How to: Prepare Database Build Scripts

Concepts

Terminology Overview of Team Edition for Database Professionals