回答編集履歴
2
修正結果が未反映だったので、再登録
test
CHANGED
|
File without changes
|
1
誤字の修正
test
CHANGED
|
@@ -20,7 +20,7 @@
|
|
|
20
20
|
|
|
21
21
|
SELECT AID FROM
|
|
22
22
|
|
|
23
|
-
( SELECT B.AID,
|
|
23
|
+
( SELECT B.AID, COUNT(B.BID) AS count FROM B WHERE B.STATUS != '完了' GROUP BY AID )
|
|
24
24
|
|
|
25
25
|
WHERE count = 0
|
|
26
26
|
|