It will throw an error saying:-
Msg 1013, Level 16, State 1, Line 1
The objects "employee_master" and "employee_master" in the FROM clause have the same exposed names. Use correlation names to distinguish them.
So, to work above query, we have to give Alias name as below:-
Select * from employee_master A,employee_master B;
Then it will execute properly and will give us output.
Asked In: Many Interviews |