Home | “The multi-part identifier “[Select field]” could not be bound.” – SQL Management Studio Error Message
Print or Email this article

“The multi-part identifier “[Select field]” could not be bound.” – SQL Management Studio Error Message

Summary

This Error Message Article explains the Microsoft SQL Management Studio error message “The multi-part identifier “[select field]” could not be bound.” and details how to fix the underlying problem that caused it to appear.

Explanation

SQL cannot find the field in the FROM part of the SQL statement called out for in the Select statement. In this case, a typo in the FROM statement, INNER JOIN for [select field #1] said [select field #2], caused the SELECT to fail.

Solution

Great care needs to be taken in writing SQL statements.

Additional Comments

Error First Appeared: Windows 2008R2, Microsoft SQL Server Management Studio for SQL 2012

Helpful Link: http://social.msdn.microsoft.com/Forums/ie/en-US/b86e9a10-9e6e-4e27-a421-f87d3200bead/the-multipart-identifier-could-not-be-bound?forum=ieextensiondevelopment

Author

Dave Klement

Was this article helpful?

Related Articles