:::: MENU ::::

The correlation name ‘%.*ls’ is specified multiple times in a FROM clause.

  • Nov 29 / 2008
  • 0
dbDigger, Derived Tables

The correlation name ‘%.*ls’ is specified multiple times in a FROM clause.

The error message
Msg 1011, Level 16, State 1, Line 1
The correlation name ‘%.*ls’ is specified multiple times in a FROM clause.

is a run time error message of severity level 16. The said error message can appear on all versions of SQL Server. This error message appears when you try to use the same name for more than one derived table within the same scope in a query. As errors of Severity Level 16 are generated by the and can be corrected by the user. To remove the error each derived table in the same scope must have a unique name.

Consult us to explore the Databases. Contact us