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
| Êîììåíòèðîâàòü | « Ïðåä. çàïèñü — Ê äíåâíèêó — Ñëåä. çàïèñü » | Ñòðàíèöû: [1] [Íîâûå] |