Self Join example in sql

Example :
   select e1.EmpName,e2.EmpName as 'Assistance'
   from EmpDetail e1
   INNER JOIN EmpDetail e2
   on e1.EmpID=e2.EmpAssID