, 01 2019 . 18:27
+
, .
1 ( ) ;
, -
SELECT . , . , . , . , . , .
FROM
INNER JOIN ON . =.
WHERE (((. ) >=[ ] And (. ) <=[ ]))
. .
2 ( )
TRANSFORM Sum(. ) AS [Sum-]
SELECT .
FROM INNER JOIN ( INNER JOIN ON . = . ) ON . = .
GROUP BY .
PIVOT . ;
, .
3. ( ).
.
, .
, !!!
https://www.sql.ru/forum/1308558/oshibki-v-zaprosah-sql
