質問編集履歴
1
項目名を修正しました
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -9,11 +9,11 @@
|
|
|
9
9
|
, S_ID AS ID
|
|
10
10
|
, SUM(TOTAL) AS 合計金額
|
|
11
11
|
FROM
|
|
12
|
-
|
|
12
|
+
POINT
|
|
13
13
|
WHERE
|
|
14
14
|
TIME BETWEEN '2015/10/01 00:00:00' AND '2015/10/01 23:59:59'
|
|
15
15
|
AND DEL_FLG = 0
|
|
16
|
-
AND
|
|
16
|
+
AND P_TYPE = 0
|
|
17
17
|
AND USAGE IS NULL
|
|
18
18
|
GROUP BY
|
|
19
19
|
S_ID
|