回答編集履歴
1
更新条件の不具合
answer
CHANGED
|
@@ -31,12 +31,12 @@
|
|
|
31
31
|
A, B, C, MAX(D)
|
|
32
32
|
FROM
|
|
33
33
|
TABLE3
|
|
34
|
-
WHERE
|
|
35
|
-
P1 IS NULL
|
|
36
|
-
AND P2 IS NULL
|
|
37
|
-
AND P3 IS NULL
|
|
38
34
|
GROUP BY
|
|
39
35
|
A, B, C
|
|
40
36
|
)
|
|
41
|
-
|
|
37
|
+
AND P1 IS NULL
|
|
38
|
+
AND P2 IS NULL
|
|
39
|
+
AND P3 IS NULL
|
|
42
|
-
```
|
|
40
|
+
```
|
|
41
|
+
追記：
|
|
42
|
+
更新条件の絞り込みが間違っていたので修正しました。
|