|
Добрый день, уважаемые форумчане!
#39647801
Ссылка:
Ссылка на сообщение:
Ссылка с названием темы:
|
|
|
|
чччД,
ччД,
так правильно ???
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.
45.
46.
47.
48.
SELECT AB4.tv as tv AB4.A AS EXV1, AB4.B AS EXV2, SUM(AB4.A+AB4.B) AS sumexv1 и тд. FROM
(SELECT EXV1 AS A, 0 AS B FROM bd2016 WHERE MONTH='ЯНВАРЬ'
UNION ALL
SELECT tovar as tv, EXV1 AS A, 0 AS B FROM bd2016 WHERE MONTH='ФЕВРАЛЬ' group by tovar,month
UNION ALL
SELECT tovar as tv,EXV1 AS A, 0 AS B FROM bd2016 WHERE MONTH='МАРТ' group by tovar,month
UNION ALL
SELECT tovar as tv,EXV1 AS A, 0 AS B FROM bd2016 WHERE MONTH='АПРЕЛЬ' group by tovar,month
UNION ALL
SELECT tovar as tv,EXV1 AS A, 0 AS B FROM bd2016 WHERE MONTH='МАЙ' group by tovar,month
UNION ALL
SELECT tovar as tv,EXV1 AS A, 0 AS B FROM bd2016 WHERE MONTH='ИЮНЬ' group by tovar,month
UNION ALL
SELECT tovar as tv,EXV1 AS A, 0 AS B FROM bd2016 WHERE MONTH='ИЮЛЬ' group by tovar,month
UNION ALL
SELECT tovar as tv,EXV1 AS A, 0 AS B FROM bd2016 WHERE MONTH='АВГУСТ' group by tovar,month
UNION ALL
SELECT tovar as tv,EXV1 AS A, 0 AS B FROM bd2016 WHERE MONTH='СЕНТЯБРЬ' group by tovar,month
UNION ALL
SELECT tovar as tv,EXV1 AS A, 0 AS B FROM bd2016 WHERE MONTH='ОКТЯБРЬ' group by tovar,month
UNION ALL
SELECT tovar as tv,EXV1 AS A, 0 AS B FROM bd2016 WHERE MONTH='НОЯБРЬ' group by tovar,month
UNION ALL
SELECT tovar as tv,EXV1 AS A, 0 AS B FROM bd2016 WHERE MONTH='ДЕКАБРЬ' group by tovar,month
UNION ALL
SELECT tovar as tv,0 AS A, EXV2 AS B FROM bd2017 WHERE MONTH='ЯНВАРЬ' group by tovar,month
UNION ALL
SELECT tovar as tv,0 AS A, EXV2 AS B FROM bd2017 WHERE MONTH='ФЕВРАЛЬ' group by tovar,month
UNION ALL
SELECT tovar as tv,0 AS A, EXV2 AS B FROM bd2017 WHERE MONTH='МАРТ' group by tovar,month
UNION ALL
SELECT tovar as tv,0 AS A, EXV2 AS B FROM bd2017 WHERE MONTH='АПРЕЛЬ' group by tovar,month
UNION ALL
SELECT tovar as tv,0 AS A, EXV2 AS B FROM bd2017 WHERE MONTH='МАЙ' group by tovar,month
UNION ALL
SELECT tovar as tv,0 AS A, EXV2 AS B FROM bd2017 WHERE MONTH='ИЮНЬ' group by tovar,month
UNION ALL
SELECT tovar as tv,0 AS A, EXV2 AS B FROM bd2017 WHERE MONTH='ИЮЛЬ' group by tovar,month
UNION ALL
SELECT tovar as tv,0 AS A, EXV2 AS B FROM bd2017 WHERE MONTH='АВГУСТ' group by tovar,month
UNION ALL
SELECT tovar as tv,0 AS A, EXV2 AS B FROM bd2017 WHERE MONTH='СЕНТЯБРЬ' group by tovar,month
UNION ALL
SELECT tovar as tv,0 AS A, EXV2 AS B FROM bd2017 WHERE MONTH='ОКТЯБРЬ' group by tovar,month
UNION ALL
SELECT tovar as tv,0 AS A, EXV2 AS B FROM bd2017 WHERE MONTH='НОЯБРЬ' group by tovar,month
UNION ALL
SELECT tovar as tv,0 AS A, EXV2 AS B FROM bd2017 WHERE MONTH='ДЕКАБРЬ' group by tovar,month) AB4 order by ab4.tv
|
|
|
