回答編集履歴
1
更新条件の不具合
test
CHANGED
|
@@ -64,20 +64,20 @@
|
|
|
64
64
|
|
|
65
65
|
TABLE3
|
|
66
66
|
|
|
67
|
-
WHERE
|
|
68
|
-
|
|
69
|
-
P1 IS NULL
|
|
70
|
-
|
|
71
|
-
AND P2 IS NULL
|
|
72
|
-
|
|
73
|
-
AND P3 IS NULL
|
|
74
|
-
|
|
75
67
|
GROUP BY
|
|
76
68
|
|
|
77
69
|
A, B, C
|
|
78
70
|
|
|
79
71
|
)
|
|
80
72
|
|
|
73
|
+
AND P1 IS NULL
|
|
81
74
|
|
|
75
|
+
AND P2 IS NULL
|
|
76
|
+
|
|
77
|
+
AND P3 IS NULL
|
|
82
78
|
|
|
83
79
|
```
|
|
80
|
+
|
|
81
|
+
追記：
|
|
82
|
+
|
|
83
|
+
更新条件の絞り込みが間違っていたので修正しました。
|