-

   rss_sql_ru_access_programming

 - e-mail

 

 -

 LiveInternet.ru:
: 16.03.2006
:
:
: 4

:


SELF JOIN .

, 19 2017 . 23:54 +

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;

.
?
Group By ON E.MentorID = E1.ID

http://www.sql.ru/forum/1263533/self-join-i-podschet-kolichestva


: [1] []
 

:
: 

: ( )

:

  URL