回答編集履歴
2
訂正
answer
CHANGED
|
@@ -16,7 +16,7 @@
|
|
|
16
16
|
UNION ALL
|
|
17
17
|
SELECT C.acol
|
|
18
18
|
, C.bcol
|
|
19
|
-
,
|
|
19
|
+
, B.ccode
|
|
20
20
|
FROM ctable C
|
|
21
21
|
LEFT JOIN btable B
|
|
22
22
|
ON C.acode = B.acode
|
1
訂正
answer
CHANGED
|
@@ -3,7 +3,7 @@
|
|
|
3
3
|
|
|
4
4
|
SQLの部分だけ、個人的にわかり易い記述で
|
|
5
5
|
```SQL
|
|
6
|
-
SELECT D
|
|
6
|
+
SELECT D.acol
|
|
7
7
|
, D.bcol
|
|
8
8
|
FROM(
|
|
9
9
|
SELECT A.acol
|