-

   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


: [1] []
 

:
: 

: ( )

:

  URL