回答編集履歴

3

例のSQLを書き間違えてました。Xの部分はbです。

2016/04/13 01:08

投稿

rysh
rysh

スコア874

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 = X.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

別の書き方を追加

2016/04/13 01:08

投稿

rysh
rysh

スコア874

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

エイリアス名を修正

2016/04/12 09:19

投稿

rysh
rysh

スコア874

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 = b.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
  ```