The objects "" and "" in the FROM clause have the same exposed names. Use correlation names to distinguish them.

If we will execute following sql query in sql server:

SELECT NULL,NULL FROM sys.objects  ,sys.objects

We will get error message like:

The objects "sys.objects" and "sys.objects" in the FROM clause have the same exposed names. Use correlation names to distinguish them.

Cause: In FROM clause if we getting data from same source table then we must have to distinguish all tables by using table alias.

Solution :

SELECT NULL,NULL

FROM sys.objects One  ,sys.objects Two