回答編集履歴
2
推敲
test
CHANGED
|
@@ -24,7 +24,7 @@
|
|
|
24
24
|
|
|
25
25
|
on t3.GROUP_ID = t2.GROUP_ID
|
|
26
26
|
|
|
27
|
-
and t2.type = 3
|
|
27
|
+
and t2.type = 3
|
|
28
28
|
|
|
29
29
|
)
|
|
30
30
|
|
1
修正
test
CHANGED
|
@@ -10,22 +10,26 @@
|
|
|
10
10
|
|
|
11
11
|
```SQL
|
|
12
12
|
|
|
13
|
-
update
|
|
13
|
+
update (
|
|
14
14
|
|
|
15
|
-
|
|
15
|
+
select t1.name, t2.ALPHA
|
|
16
16
|
|
|
17
|
-
|
|
17
|
+
from Teble_A t1
|
|
18
18
|
|
|
19
|
-
|
|
19
|
+
inner join Teble_C t3
|
|
20
20
|
|
|
21
|
-
|
|
21
|
+
on t1.MEMBER_ID = t3.MEMBER_ID
|
|
22
22
|
|
|
23
|
-
|
|
23
|
+
inner join Teble_B t2
|
|
24
24
|
|
|
25
|
+
on t3.GROUP_ID = t2.GROUP_ID
|
|
26
|
+
|
|
25
|
-
and t2.type = 3
|
|
27
|
+
and t2.type = 3
|
|
28
|
+
|
|
29
|
+
)
|
|
26
30
|
|
|
27
31
|
set
|
|
28
32
|
|
|
29
|
-
|
|
33
|
+
name = name || '(' || ALPHA || ')'
|
|
30
34
|
|
|
31
35
|
```
|