質問編集履歴

2

SQL表示方法修正

2018/07/11 08:34

投稿

taiyo-2017
taiyo-2017

スコア49

test CHANGED
File without changes
test CHANGED
@@ -16,33 +16,65 @@
16
16
 
17
17
  ```SQL
18
18
 
19
- select p.ww,
19
+ select
20
+
20
-
21
+ p.ww,
22
+
21
- c.xx,
23
+ c.xx,
22
-
24
+
23
- r1.yy,
25
+ r1.yy,
24
-
26
+
25
- w.zz
27
+ w.zz
28
+
26
-
29
+ from
30
+
31
+ C c
32
+
27
- from C c right join ((R r2 right join ((
33
+ right join (
28
-
34
+
29
- (
35
+ (
36
+
30
-
37
+ R r2
38
+
39
+ right join (
40
+
41
+ (
42
+
43
+ (
44
+
45
+ SELECT
46
+
47
+ aa,
48
+
49
+ bb,
50
+
51
+ ee,
52
+
53
+ yy
54
+
55
+ FROM
56
+
57
+ L
58
+
31
- SELECT aa, bb, ee, yy FROM L inner JOIN P ON L.aa = P.aa
59
+ inner JOIN P ON L.aa = P.aa
32
-
60
+
33
- ) r1 right
61
+ ) r1
34
-
62
+
35
- join P p on r1.aa = p.aa) left join RF rf
63
+ right join P p on r1.aa = p.aa
64
+
36
-
65
+ )
66
+
67
+ left join RF rf on r1.bb = rf.bb
68
+
37
- on r1.bb = rf.bb) on r2.cc =
69
+ ) on r2.cc = rf.cc
70
+
38
-
71
+ )
72
+
39
- rf.cc) left join D d on p.dd = d.dd)
73
+ left join D d on p.dd = d.dd
40
-
74
+
41
- on c.ee = r1.ee
75
+ ) on c.ee = r1.ee
42
-
43
- inner join W w
76
+
44
-
45
- on w.ff = "AAA"
77
+ inner join W w on w.ff = "AAA"
46
78
 
47
79
  ORDER BY
48
80
 

1

SQLの記述を修正

2018/07/11 08:34

投稿

taiyo-2017
taiyo-2017

スコア49

test CHANGED
File without changes
test CHANGED
@@ -14,6 +14,8 @@
14
14
 
15
15
  ### 作成したいsql
16
16
 
17
+ ```SQL
18
+
17
19
  select p.ww,
18
20
 
19
21
  c.xx,
@@ -46,7 +48,7 @@
46
48
 
47
49
  p.gg ASC
48
50
 
49
-
51
+ ```
50
52
 
51
53
 
52
54