回答編集履歴
2
訂正
answer
CHANGED
|
@@ -5,10 +5,11 @@
|
|
|
5
5
|
,a.meta_value AS FullName
|
|
6
6
|
,b.meta_value AS Age
|
|
7
7
|
FROM
|
|
8
|
-
wp_usermeta a JOIN wp_usermeta b ON
|
|
8
|
+
wp_usermeta AS a INNER JOIN wp_usermeta AS b ON
|
|
9
|
+
a.EmpID = b.EmpID
|
|
10
|
+
WHERE
|
|
9
|
-
|
|
11
|
+
a.meta_key = 'FullName'
|
|
10
|
-
|
|
12
|
+
AND b.meta_key = 'Age'
|
|
11
|
-
AND a.EmpID = b.EmpID
|
|
12
13
|
ORDER BY
|
|
13
14
|
a.EmpID
|
|
14
15
|
```
|
1
ORDER BYを追加
answer
CHANGED
|
@@ -9,4 +9,6 @@
|
|
|
9
9
|
a.meta_key = 'FullName'
|
|
10
10
|
AND b.meta_key = 'Age'
|
|
11
11
|
AND a.EmpID = b.EmpID
|
|
12
|
+
ORDER BY
|
|
13
|
+
a.EmpID
|
|
12
14
|
```
|