1. Home
  2. Database
  3. SQL Server
  4. SQL Server Error Messages
  5. “Error in SELECT clause: expression near ‘[field reference]’. Missing FROM clause.” – SQL Management Studio Error Message

“Error in SELECT clause: expression near ‘[field reference]’. Missing FROM clause.” – SQL Management Studio Error Message

Summary

This Error Message Article explains the Microsoft SQL Server Management Studio error message “SQL Syntax Errors Encountered The following errors were encountered while parsing the contents of the SQL pane: Error in SELECT clause: expression near ‘[field reference]’. Missing FROM clause.” and details how to fix the underlying problem that caused it to appear.

Explanation

SQL is unable to execute the SELECT statement because it cannot find the field reference value in the FROM clause. In this case, there was a typo in the SELECT statement (missing a comma between field references) so SQL put the two references together and could not recognize the new, incorrect, statement in the FROM clause.

Solution

Great care needs to be take in writing and executing SQL statements.  In this case, a neglected comma needed to be added to the statement.

Additional Comments

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

Related Article: Problem Article – SQL Query Typos – KBA-01301

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