çàïðîñ íà âûâîä äàííûõ ïî óíèêàëüíûì ñî÷èòàíèÿì ïîëåé |

SELECT Êàëåíäàð.Äàòà, Ãðóïè.Øèôð_ãðóïè, Ðîçêëàä.ïðåäìåò, Òåìè_çàíÿòü.òåìà, Ðîçêëàä.Âèä_çàíÿòòÿ, Êàëåíäàð.[ê³ëüê³ñòü ÷àñ³â] FROM Òèæäåíü INNER JOIN (Òåìè_çàíÿòü INNER JOIN (Íàâ÷àëüí³_äèñöèïë³íè INNER JOIN ((Äí³_òèæíÿ INNER JOIN Êàëåíäàð ON Äí³_òèæíÿ.Êîä_äíÿ = Êàëåíäàð.Äåíü) INNER JOIN (Ãðóïè INNER JOIN Ðîçêëàä ON Ãðóïè.Êîä_ãðóïè = Ðîçêëàä.Êîä_ãðóïè) ON Äí³_òèæíÿ.Êîä_äíÿ = Ðîçêëàä.Êîä_äíÿ) ON Íàâ÷àëüí³_äèñöèïë³íè.Êîä_äèñöèïë³íè = Ðîçêëàä.ïðåäìåò) ON Òåìè_çàíÿòü.Êîä_òåìè = Íàâ÷àëüí³_äèñöèïë³íè.Òåìè.Value) ON (Òèæäåíü.Êîä_òèæíÿ = Ðîçêëàä.Êîä_òèæíÿ) AND (Òèæäåíü.Êîä_òèæíÿ = Êàëåíäàð.Òèæäåíü) WHERE (((Ðîçêëàä.ïðåäìåò) Is Not Null)) ORDER BY Êàëåíäàð.Äàòà, Ðîçêëàä.Êîä_ïàðè, Òåìè_çàíÿòü.Êîä_òåìè;
http://www.sql.ru/forum/1103728/zapros-na-vyvod-dannyh-po-unikalnym-sochitaniyam-poley
| Êîììåíòèðîâàòü | « Ïðåä. çàïèñü — Ê äíåâíèêó — Ñëåä. çàïèñü » | Ñòðàíèöû: [1] [Íîâûå] |