回答編集履歴
2
推敲
answer
CHANGED
|
@@ -11,7 +11,7 @@
|
|
|
11
11
|
on t1.MEMBER_ID = t3.MEMBER_ID
|
|
12
12
|
inner join Teble_B t2
|
|
13
13
|
on t3.GROUP_ID = t2.GROUP_ID
|
|
14
|
-
|
|
14
|
+
and t2.type = 3
|
|
15
15
|
)
|
|
16
16
|
set
|
|
17
17
|
name = name || '(' || ALPHA || ')'
|
1
修正
answer
CHANGED
|
@@ -4,13 +4,15 @@
|
|
|
4
4
|
|
|
5
5
|
尚、以下のように記述すると、編集記述の可読性が上がります。
|
|
6
6
|
```SQL
|
|
7
|
-
update
|
|
7
|
+
update (
|
|
8
|
+
select t1.name, t2.ALPHA
|
|
8
|
-
Teble_A t1
|
|
9
|
+
from Teble_A t1
|
|
9
|
-
|
|
10
|
+
inner join Teble_C t3
|
|
10
|
-
|
|
11
|
+
on t1.MEMBER_ID = t3.MEMBER_ID
|
|
11
|
-
|
|
12
|
+
inner join Teble_B t2
|
|
12
|
-
|
|
13
|
+
on t3.GROUP_ID = t2.GROUP_ID
|
|
13
|
-
|
|
14
|
+
and t2.type = 3
|
|
15
|
+
)
|
|
14
16
|
set
|
|
15
|
-
|
|
17
|
+
name = name || '(' || ALPHA || ')'
|
|
16
18
|
```
|