Óñëîâèå îòáîðà áåç ïîâòîðåíèé â Access
|
|
Ïÿòíèöà, 05 Ìàÿ 2017 ã. 12:07
+ â öèòàòíèê
Íèæå ìîé SQL çàïðîñ. Ïðîøó ïîìî÷ü êîãî-íèáóäü îòêîððåêòèðîâàòü SQL çàïðîñ òàê, ÷òîáû â îòáîðå íå áûëî
ïîâòîðåíèé çàïèñåé â çàïðîñå ïî ïîëþ [Ãëàâíàÿ òàáëèöà].Êîä. ß çíàþ ÷òî ýòî äåëàåòñÿ ïðè ïîìîùè DISTINCT èëè DISTINCTROW, íî íå çíàþ êàê ïðàâèëüíî. ( åñëè òóïî âñòàâëÿþ ïåðåä Selest, òî âûäàåò îøèáêó "Çàðåçåðâèðîâàííîå ñëîâî DISTINCT íå ìîæåò èñïîëüçîâàòüñÿ ñ ïîëåì [Ãëàâíàÿ òàáëèöà].[Ïðè÷èíû çàäåðæêè], îäíîâðåìåííî äîïóñêàþùèì íåñêîëüêî çíà÷åíèé.
ÏÎÌÎÃÈÒÅ ÏÎÆÀËÓÉÑÒÀ
SELECT [Ãëàâíàÿ òàáëèöà].Äàòà, [Ãëàâíàÿ òàáëèöà].Âîäèòåëü, [Ãëàâíàÿ òàáëèöà].[Òèï ÒÑ], [Ñîäåðæàíèå çàÿâêè].[Îòâåòñòâåííûé çà ïîãðóçêó], [Ñîäåðæàíèå çàÿâêè].[Îòâåòñòâåííûé çà ðàçãðóçêó], [Ñîäåðæàíèå çàÿâêè].[Ìåñòî ïîãðóçêè], [Ñîäåðæàíèå çàÿâêè].[Ìåñòî ðàçãðóçêè], [Ãëàâíàÿ òàáëèöà].[Ïðîñòîé íà ïîãðóçêå], [Ãëàâíàÿ òàáëèöà].[Ïðîñòîé íà ðàçãðóçêå], [Ãëàâíàÿ òàáëèöà].[Ïðè÷èíû çàäåðæêè].Value, [Ãëàâíàÿ òàáëèöà].[Ïðè÷èíû çàäåðæêè], [Ãëàâíàÿ òàáëèöà].Êîä
FROM [Ãëàâíàÿ òàáëèöà] RIGHT JOIN [Ñîäåðæàíèå çàÿâêè] ON [Ãëàâíàÿ òàáëèöà].Êîä = [Ñîäåðæàíèå çàÿâêè].id_p
WHERE ((([Ãëàâíàÿ òàáëèöà].[Ïðè÷èíû çàäåðæêè].Value)<>"IsNull"))
ORDER BY [Ãëàâíàÿ òàáëèöà].Äàòà;
http://www.sql.ru/forum/1259249/uslovie-otbora-bez-povtoreniy-v-access
-
Çàïèñü ïîíðàâèëàñü
-
0
Ïðîöèòèðîâàëè
-
0
Ñîõðàíèëè
-