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


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.


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.


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


Was this article helpful?

Related Articles