The column prefix ‘A’ does not match with a table name or alias name used in the query

Posted on : 17-05-2012 | By : Devi Prasad | In : Msg 107, SQL Errors

0



Error Message:

Msg 107, Level 15, State 1, Line 1
The column prefix ‘A’ does not match with a table name or alias name used in the query.

This error occurs when the correct table name/alias is not used in the select query.

Example:

SELECT a.* FROM SYS.tables 

When you execute the above code you get error message Msg 107.

Fix/Resolution:
Correct the select list with the correct table names or alias names.

SELECT sys.tables.* FROM sys.tables
SELECT tables.* FROM sys.tables
SELECT T.* FROM sys.tables T



Reference : Devi Prasad (sqlserverlearner.com)

Do you like my blog?

If you liked reading this blog, please help spread the word by sharing this blog with your friends.



Need Help On SQL Server?

Cannot Find Solution to your problem (or) If you are looking for some help on SQL Server. Dont worry Click Here to Post your question and solve your issue.




Your Ad Here


Tags: ,