Çàïðîñ íà âûáîðêó ñòóäåíòîâ
|
|
Ñóááîòà, 30 Àâãóñòà 2014 ã. 13:47
+ â öèòàòíèê
Çàïðîñ ïî âûâîäó ñòóäåíòîâ è äàò ïîëó÷åíèÿ èìè ãðóïï è ïðîãðàìì ÄÎ ÑÅÑÑÈÈ:
SELECT [Ïðîãðàììà/ñòóäåíò].ID_ñòóäåíòà, Max([Ãðóïïà/ñòóäåíò].[Äàòà ïðèñâîåíèÿ]) AS [MaxOfÄàòà ïðèñâîåíèÿ]
FROM (Ïîòîêè INNER JOIN ÃðàôèêÑåññèé ON Ïîòîêè.ID_ïîòîêà = ÃðàôèêÑåññèé.ID_ïîòîêà) INNER JOIN ((Ãðóïïû INNER JOIN [Ãðóïïà/ñòóäåíò] ON Ãðóïïû.[ID ãðóïïû] = [Ãðóïïà/ñòóäåíò].ID_ãðóïïû) INNER JOIN ([Ïðîãðàììà/ñòóäåíò] LEFT JOIN ÏðåäìåòûQ ON [Ïðîãðàììà/ñòóäåíò].ID_ïðîãðàììû = ÏðåäìåòûQ.ID_ïðîãðàììû) ON [Ãðóïïà/ñòóäåíò].ID_ñòóäåíòà = [Ïðîãðàììà/ñòóäåíò].ID_ñòóäåíòà) ON Ïîòîêè.ID_ïîòîêà = Ãðóïïû.ID_ïîòîêà
GROUP BY [Ïðîãðàììà/ñòóäåíò].ID_ñòóäåíòà
HAVING (((Max([Ïðîãðàììà/ñòóäåíò].[Äàòà çà÷èñëåíèÿ]))<=[ÃðàôèêÑåññèé]![Íà÷àëî]) AND ((Max([Ãðóïïà/ñòóäåíò].[Äàòà ïðèñâîåíèÿ]))<=[ÃðàôèêÑåññèé]![Íà÷àëî]));
Ñîáñòâåííî, çàïðîñ íå ïðèíèìàåò óñëîâèÿ (<=[ÃðàôèêÑåññèé]![Íà÷àëî]). Ïèøåò îøèáêó 3122.
http://www.sql.ru/forum/1113397/zapros-na-vyborku-studentov
-
Çàïèñü ïîíðàâèëàñü
-
0
Ïðîöèòèðîâàëè
-
0
Ñîõðàíèëè
-