回答編集履歴
2
誤記の修正
test
CHANGED
|
@@ -86,7 +86,7 @@
|
|
|
86
86
|
|
|
87
87
|
LEFT JOIN test1
|
|
88
88
|
|
|
89
|
-
ON Test.
|
|
89
|
+
ON Test.出身地 = test1.コード
|
|
90
90
|
|
|
91
91
|
```
|
|
92
92
|
|
|
@@ -110,7 +110,7 @@
|
|
|
110
110
|
|
|
111
111
|
LEFT JOIN test1
|
|
112
112
|
|
|
113
|
-
ON Test.
|
|
113
|
+
ON Test.出身地 = test1.コード)
|
|
114
114
|
|
|
115
115
|
LEFT JOIN test2
|
|
116
116
|
|
1
誤記の修正
test
CHANGED
|
@@ -80,7 +80,7 @@
|
|
|
80
80
|
|
|
81
81
|
```MySQL
|
|
82
82
|
|
|
83
|
-
SELECT Test.社員番号,Test.名前,test1.都道府県
|
|
83
|
+
SELECT Test.社員番号,Test.名前,test1.都道府県
|
|
84
84
|
|
|
85
85
|
FROM Test
|
|
86
86
|
|
|
@@ -104,7 +104,7 @@
|
|
|
104
104
|
|
|
105
105
|
```MySQL
|
|
106
106
|
|
|
107
|
-
SELECT Test.社員番号,Test.名前,test1.都道府県,
|
|
107
|
+
SELECT Test.社員番号,Test.名前,test1.都道府県,test2.部署
|
|
108
108
|
|
|
109
109
|
FROM (Test
|
|
110
110
|
|