回答編集履歴
3
修正
answer
CHANGED
|
@@ -7,7 +7,7 @@
|
|
|
7
7
|
|
|
8
8
|
質問２.タマゴ AND ケチャップ を使用している料理
|
|
9
9
|
```sql
|
|
10
|
-
select distinct
|
|
10
|
+
select distinct table1_name from (select table1_id, table1_name from table1
|
|
11
11
|
join table12 t12 using(table1_id) join table2 t2 on t12.table2_id=t2.table2_id
|
|
12
12
|
and t2.table2_name='ケチャップ') t10
|
|
13
13
|
join (select table1_id from table1 join table12 t12 using(table1_id)
|
2
修正
answer
CHANGED
|
@@ -7,10 +7,10 @@
|
|
|
7
7
|
|
|
8
8
|
質問２.タマゴ AND ケチャップ を使用している料理
|
|
9
9
|
```sql
|
|
10
|
-
select distinct t10.table1_name from
|
|
11
|
-
|
|
10
|
+
select distinct t10.table1_name from (select table1_id, table1_name from table1
|
|
12
|
-
join table2
|
|
11
|
+
join table12 t12 using(table1_id) join table2 t2 on t12.table2_id=t2.table2_id
|
|
12
|
+
and t2.table2_name='ケチャップ') t10
|
|
13
|
-
|
|
13
|
+
join (select table1_id from table1 join table12 t12 using(table1_id)
|
|
14
|
-
|
|
14
|
+
join table2 t2 on t12.table2_id=t2.table2_id
|
|
15
|
-
t11 using(table1_id);
|
|
15
|
+
and t2.table2_name='タマゴ') t11 using(table1_id);
|
|
16
16
|
```
|
1
修正
answer
CHANGED
|
@@ -10,7 +10,7 @@
|
|
|
10
10
|
select distinct t10.table1_name from
|
|
11
11
|
(select table1_id, table1_name from table1 join table12 t12 using(table1_id)
|
|
12
12
|
join table2 t2_1 on t12.table2_id=t2_1.table2_id and t2_1.table2_name='ケチャップ') t10
|
|
13
|
-
join (select table1_id
|
|
13
|
+
join (select table1_id from table1 join table12 t12 using(table1_id)
|
|
14
14
|
join table2 t2_1 on t12.table2_id=t2_1.table2_id and t2_1.table2_name='タマゴ')
|
|
15
15
|
t11 using(table1_id);
|
|
16
16
|
```
|