回答編集履歴
3
例のSQLを書き間違えてました。Xの部分はbです。
test
CHANGED
@@ -2,7 +2,7 @@
|
|
2
2
|
|
3
3
|
```SQL
|
4
4
|
|
5
|
-
SELECT * FROM ( select * from a INNER JOIN b ON a.XXX = b.XXX WHERE A.YYY = x ) X RIGHT JOIN c ON c.ZZZ =
|
5
|
+
SELECT * FROM ( select * from a INNER JOIN b ON a.XXX = b.XXX WHERE A.YYY = x ) X RIGHT JOIN c ON c.ZZZ = b.ZZZ
|
6
6
|
|
7
7
|
```
|
8
8
|
|
2
別の書き方を追加
test
CHANGED
@@ -5,3 +5,19 @@
|
|
5
5
|
SELECT * FROM ( select * from a INNER JOIN b ON a.XXX = b.XXX WHERE A.YYY = x ) X RIGHT JOIN c ON c.ZZZ = X.ZZZ
|
6
6
|
|
7
7
|
```
|
8
|
+
|
9
|
+
|
10
|
+
|
11
|
+
あるいは、こう書きたいのでしょうか?
|
12
|
+
|
13
|
+
```SQL
|
14
|
+
|
15
|
+
SELECT * FROM a
|
16
|
+
|
17
|
+
INNER JOIN b ON a.XXX = b.XXX
|
18
|
+
|
19
|
+
RIGHT JOIN c ON c.ZZZ = X.ZZZ
|
20
|
+
|
21
|
+
WHERE A.YYY = x
|
22
|
+
|
23
|
+
```
|
1
エイリアス名を修正
test
CHANGED
@@ -2,6 +2,6 @@
|
|
2
2
|
|
3
3
|
```SQL
|
4
4
|
|
5
|
-
SELECT * FROM ( select * from a INNER JOIN b ON a.XXX = b.XXX WHERE A.YYY = x ) X RIGHT JOIN c ON c.ZZZ =
|
5
|
+
SELECT * FROM ( select * from a INNER JOIN b ON a.XXX = b.XXX WHERE A.YYY = x ) X RIGHT JOIN c ON c.ZZZ = X.ZZZ
|
6
6
|
|
7
7
|
```
|