回答編集履歴
1
回答を修正
answer
CHANGED
|
@@ -1,6 +1,6 @@
|
|
|
1
1
|
手元に MariaDB の環境が無いので、MySQLで動作確認してあります。
|
|
2
2
|
```sql
|
|
3
|
-
SELECT c.id, c.name,
|
|
3
|
+
SELECT c.id, c.name, a.avol, b.bvol
|
|
4
4
|
FROM table_c AS c
|
|
5
5
|
LEFT OUTER JOIN (
|
|
6
6
|
SELECT id, SUM(avol) AS avol FROM table_a GROUP BY id
|
|
@@ -8,7 +8,6 @@
|
|
|
8
8
|
LEFT OUTER JOIN (
|
|
9
9
|
SELECT id, SUM(bvol) AS bvol FROM table_b GROUP BY id
|
|
10
10
|
) AS b ON c.id = b.id
|
|
11
|
-
GROUP BY c.id
|
|
12
11
|
ORDER BY c.id;
|
|
13
12
|
```
|
|
14
|
-
[http://sqlfiddle.com/#!9/d249d6/
|
|
13
|
+
[http://sqlfiddle.com/#!9/d249d6/10](http://sqlfiddle.com/#!9/d249d6/10)
|