回答編集履歴
2
訂正
test
CHANGED
@@ -12,13 +12,15 @@
|
|
12
12
|
|
13
13
|
FROM
|
14
14
|
|
15
|
-
wp_usermeta a JOIN wp_usermeta b ON
|
15
|
+
wp_usermeta AS a INNER JOIN wp_usermeta AS b ON
|
16
16
|
|
17
|
-
a.m
|
17
|
+
a.EmpID = b.EmpID
|
18
18
|
|
19
|
-
|
19
|
+
WHERE
|
20
20
|
|
21
|
+
a.meta_key = 'FullName'
|
22
|
+
|
21
|
-
|
23
|
+
AND b.meta_key = 'Age'
|
22
24
|
|
23
25
|
ORDER BY
|
24
26
|
|
1
ORDER BYを追加
test
CHANGED
@@ -20,4 +20,8 @@
|
|
20
20
|
|
21
21
|
AND a.EmpID = b.EmpID
|
22
22
|
|
23
|
+
ORDER BY
|
24
|
+
|
25
|
+
a.EmpID
|
26
|
+
|
23
27
|
```
|