回答編集履歴
1
文法修正
test
CHANGED
@@ -4,18 +4,16 @@
|
|
4
4
|
|
5
5
|
```SQL
|
6
6
|
|
7
|
-
SELECT
|
7
|
+
SELECT t1.post_id
|
8
8
|
|
9
9
|
FROM table t1
|
10
10
|
|
11
11
|
LEFT OUTER JOIN table t2 ON t1.post_id = t2.post_id
|
12
12
|
|
13
|
-
WHERE t1.category_id = 3 AND t2.category_id = 4
|
13
|
+
WHERE t1.category_id = 3 AND t2.category_id = 4;
|
14
|
-
|
15
|
-
OR t1.category_id = 4 AND t2.category_id = 3;
|
16
14
|
|
17
15
|
```
|
18
16
|
|
19
17
|
|
20
18
|
|
21
|
-
DISTINCT
|
19
|
+
同じテーブル同士なのでOR文やDISTINCTは不要でしたね。
|