SELF JOIN . |
SELECT E.ID, E.SecondName AS , E.FirstName AS , E.MiddleName AS , E.Phone AS , P.Title AS , E1.SecondName + ' '+ E1.FirstName AS , E.Address AS , E.PositionID FROM (Employee AS E INNER JOIN [Position] AS P ON E.PositionID = P.ID) INNER JOIN Employee AS E1 ON E.MentorID = E1.ID;
http://www.sql.ru/forum/1263533/self-join-i-podschet-kolichestva