LEFT JOIN |
Weeks PG
201624 Cat1
201624 Cat2
201623 Cat1
201623 Cat2
201622 Cat1
201622 Cat2
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
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));
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