回答編集履歴
1
Fix bug, Simplify
test
CHANGED
|
@@ -6,7 +6,7 @@
|
|
|
6
6
|
|
|
7
7
|
```sql
|
|
8
8
|
|
|
9
|
-
SELECT XYZ.
|
|
9
|
+
SELECT XYZ.#, XYZ.A, XYZ.B, XYZ.C, XYZ.D, INLINE.# AS ※1
|
|
10
10
|
|
|
11
11
|
FROM XYZ
|
|
12
12
|
|
|
@@ -34,15 +34,15 @@
|
|
|
34
34
|
|
|
35
35
|
1|1000|201|002|1A|1
|
|
36
36
|
|
|
37
|
-
2|1000|202|001|1A|
|
|
37
|
+
2|1000|202|001|1A|2
|
|
38
38
|
|
|
39
|
-
3|1000|202|002|1A|
|
|
39
|
+
3|1000|202|002|1A|3
|
|
40
40
|
|
|
41
|
-
4|1000|203|001|1A|
|
|
41
|
+
4|1000|203|001|1A|4
|
|
42
42
|
|
|
43
|
-
5|1000|204|001|2A|
|
|
43
|
+
5|1000|204|001|2A|NULL
|
|
44
44
|
|
|
45
|
-
6|1000|204|002|2A|
|
|
45
|
+
6|1000|204|002|2A|NULL
|
|
46
46
|
|
|
47
47
|
|
|
48
48
|
|