1. Home
  2. Database
  3. SQL Server
  4. SQL Server Error Messages
  5. “The multi-part identifier “[Select field]” could not be bound.” – SQL Management Studio Error Message

“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

Updated on August 1, 2017

Was this article helpful?

Need Support?
Can’t find the answer you’re looking for? Don’t worry we’re here to help!
Contact Support