what is self join in sql server

here you can see the use of self join or what is self join in sql server.

the word self join means the table is join with it self it's called the self join.

the example of the self join is..

suppose we have to get the information from the table that is there any field that can contain the same value

then we can find the information wth the self join as below.

select * from employee e,employee f where e.emp_name=f.emp_name.