SQL Server error code
SQL Server error 107
SQL Server raises error 107 at severity 15, which marks a problem with the query or data that you can correct.
The column prefix '%.*ls' does not match with a table name or alias name used in the query.
| Msg | 107 |
|---|---|
| Name | P_NOCORRMATCH |
| Severity | 15 |
| Group | 0–999 |
What it means
The select list of the query contains an asterisk (*) that is incorrectly qualified with a column prefix. This error can be returned under the following conditions:
The column prefix does not correspond to any table or alias name used in the query. For example, the following statement uses an alias name (T1) as a column prefix, but the alias is not defined in the FROM clause.
A table name is specified as a column prefix when an alias name for the table is supplied in the FROM clause. For example, the following statement uses the table name ErrorLog as the column prefix; however, the table has an alias (T1) defined in the FROM clause.