-Ïîèñê ïî äíåâíèêó

Ïîèñê ñîîáùåíèé â 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


 

Äîáàâèòü êîììåíòàðèé:
Òåêñò êîììåíòàðèÿ: ñìàéëèêè

Ïðîâåðêà îðôîãðàôèè: (íàéòè îøèáêè)

Ïðèêðåïèòü êàðòèíêó:

 Ïåðåâîäèòü URL â ññûëêó
 Ïîäïèñàòüñÿ íà êîììåíòàðèè
 Ïîäïèñàòü êàðòèíêó