回答編集履歴
3
修正
test
CHANGED
|
@@ -16,7 +16,7 @@
|
|
|
16
16
|
|
|
17
17
|
```sql
|
|
18
18
|
|
|
19
|
-
select distinct t
|
|
19
|
+
select distinct table1_name from (select table1_id, table1_name from table1
|
|
20
20
|
|
|
21
21
|
join table12 t12 using(table1_id) join table2 t2 on t12.table2_id=t2.table2_id
|
|
22
22
|
|
2
修正
test
CHANGED
|
@@ -16,16 +16,16 @@
|
|
|
16
16
|
|
|
17
17
|
```sql
|
|
18
18
|
|
|
19
|
-
select distinct t10.table1_name from
|
|
19
|
+
select distinct t10.table1_name from (select table1_id, table1_name from table1
|
|
20
20
|
|
|
21
|
-
|
|
21
|
+
join table12 t12 using(table1_id) join table2 t2 on t12.table2_id=t2.table2_id
|
|
22
22
|
|
|
23
|
-
|
|
23
|
+
and t2.table2_name='ケチャップ') t10
|
|
24
24
|
|
|
25
|
-
|
|
25
|
+
join (select table1_id from table1 join table12 t12 using(table1_id)
|
|
26
26
|
|
|
27
|
-
|
|
27
|
+
join table2 t2 on t12.table2_id=t2.table2_id
|
|
28
28
|
|
|
29
|
-
t11 using(table1_id);
|
|
29
|
+
and t2.table2_name='タマゴ') t11 using(table1_id);
|
|
30
30
|
|
|
31
31
|
```
|
1
修正
test
CHANGED
|
@@ -22,7 +22,7 @@
|
|
|
22
22
|
|
|
23
23
|
join table2 t2_1 on t12.table2_id=t2_1.table2_id and t2_1.table2_name='ケチャップ') t10
|
|
24
24
|
|
|
25
|
-
join (select table1_id
|
|
25
|
+
join (select table1_id from table1 join table12 t12 using(table1_id)
|
|
26
26
|
|
|
27
27
|
join table2 t2_1 on t12.table2_id=t2_1.table2_id and t2_1.table2_name='タマゴ')
|
|
28
28
|
|