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

Ïîèñê ñîîáùåíèé â rss_sql_ru_access_programming

 -Ïîäïèñêà ïî e-mail

 

 -Ïîñòîÿííûå ÷èòàòåëè

 -Ñòàòèñòèêà

Ñòàòèñòèêà LiveInternet.ru: ïîêàçàíî êîëè÷åñòâî õèòîâ è ïîñåòèòåëåé
Ñîçäàí: 16.03.2006
Çàïèñåé:
Êîììåíòàðèåâ:
Íàïèñàíî: 4


Íå ðàáîòàåò ïðîñòåéøèé LEFT JOIN

Ñðåäà, 15 Èþíÿ 2016 ã. 17:21 + â öèòàòíèê
Äîáðûé äåíü âñåì!
Âòîðîé äåíü íå ìîãó ðàçîáðàòüñÿ ïî÷åìó íå ðàáîòàåò ïðîñòîé LEFT JOIN â MS ACCESS 2013.
Èìååì 2 çàïðîñà, êîòîðûå âûäàþò 2 ïðîñòûå òàáëèöû òàêîãî âèäà:

Çàïðîñ 1 "SelectPgWk"

Weeks	PG
201624 Cat1
201624 Cat2
201623 Cat1
201623 Cat2
201622 Cat1
201622 Cat2

Çàïðîñ 2 "SelectPgWkVal"

Weeks	PG	SumValue
201624 Cat1 3311,13
201622 Cat2 757,25
201621 Cat3 2114,23
201620 Cat3 11456,66
201619 Cat2 11768,99
201617 Cat4 95,59

Íåîáõîäèìî êî âñåì ñòðîêàì ïåðâîé òàáëèöû äîáàâèòü 3-þ êîëîíêó âòîðîé òàáëèöû ãäå ñîâïàäàþò ïåðâûå äâå, êàê-òî òàê:

Weeks	PG	Res
201624 Cat1 3311,13
201624 Cat2 0
201623 Cat1 0
201623 Cat2 0
201622 Cat1 0
201622 Cat2 757,25

Ïèøó âîò òàêîé çàïðîñ:

SELECT W.Weeks, W.PG, V.SumValue AS Res
FROM SelectPgWk AS W LEFT JOIN SelectPgWkVal AS V ON ((W.PG = V.PG) AND (W.Weeks = V.Weeks));


.. è ïîëó÷àþ ïóñòóþ êîëîíêó Res:

Weeks	PG	Res
201622 Cat1
201623 Cat1
201624 Cat1
201622 Cat2
201623 Cat2
201624 Cat2

Òêíèòå ïîæàëóéñòà íåîïûòíîãî ãäå ÿ òóïëþ.
Çàðàíåå áëàãîäàðåí.

http://www.sql.ru/forum/1218363/ne-rabotaet-prosteyshiy-left-join


 

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

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

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

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