回答編集履歴
2
問題の読み違えで結合条件ではなく、選択条件が違っていたため、選択条件を変更
test
CHANGED
|
@@ -12,11 +12,13 @@
|
|
|
12
12
|
|
|
13
13
|
on t1.transaction_id=t2.transaction_id
|
|
14
14
|
|
|
15
|
-
and t1.question_id=t2.question_id
|
|
16
|
-
|
|
17
15
|
where
|
|
18
16
|
|
|
17
|
+
t1.question_id=100
|
|
18
|
+
|
|
19
|
-
t1.answer='回答1'
|
|
19
|
+
and t1.answer='回答1'
|
|
20
|
+
|
|
21
|
+
and t2.question_id=101
|
|
20
22
|
|
|
21
23
|
and t2.answer='回答2';
|
|
22
24
|
|
1
question_idを結合条件に追加
test
CHANGED
|
@@ -12,6 +12,8 @@
|
|
|
12
12
|
|
|
13
13
|
on t1.transaction_id=t2.transaction_id
|
|
14
14
|
|
|
15
|
+
and t1.question_id=t2.question_id
|
|
16
|
+
|
|
15
17
|
where
|
|
16
18
|
|
|
17
19
|
t1.answer='回答1'
|