回答編集履歴
4
変更
test
CHANGED
@@ -10,7 +10,7 @@
|
|
10
10
|
|
11
11
|
sum(case when zan<0 then zan else 0 end) 消費量合計
|
12
12
|
|
13
|
-
from tbl01 t1
|
13
|
+
from tbl01 t1 join tbl02 t2
|
14
14
|
|
15
15
|
on t1.kaiin=t2.kaiin and kingaku>=5000
|
16
16
|
|
3
変更
test
CHANGED
File without changes
|
2
変更
test
CHANGED
@@ -8,9 +8,9 @@
|
|
8
8
|
|
9
9
|
sum(zan) 残量,
|
10
10
|
|
11
|
-
sum(case when zan<0 then zan else
|
11
|
+
sum(case when zan<0 then zan else 0 end) 消費量合計
|
12
12
|
|
13
|
-
from tbl01 t1 join tbl02 t2
|
13
|
+
from tbl01 t1 left join tbl02 t2
|
14
14
|
|
15
15
|
on t1.kaiin=t2.kaiin and kingaku>=5000
|
16
16
|
|
1
変更
test
CHANGED
@@ -8,7 +8,7 @@
|
|
8
8
|
|
9
9
|
sum(zan) 残量,
|
10
10
|
|
11
|
-
sum(case when zan<0 then zan else
|
11
|
+
sum(case when zan<0 then zan else null end) 消費量合計
|
12
12
|
|
13
13
|
from tbl01 t1 join tbl02 t2
|
14
14
|
|