回答編集履歴
1
変更
test
CHANGED
|
@@ -5,8 +5,6 @@
|
|
|
5
5
|
```sql
|
|
6
6
|
|
|
7
7
|
SELECT * FROM (
|
|
8
|
-
|
|
9
|
-
SELECT * FROM (
|
|
10
8
|
|
|
11
9
|
SELECT date_format(now(), '%Y.%m.%d') as date
|
|
12
10
|
|
|
@@ -34,15 +32,13 @@
|
|
|
34
32
|
|
|
35
33
|
SELECT date_format(now() + interval 6 day, '%Y.%m.%d')
|
|
36
34
|
|
|
37
|
-
|
|
35
|
+
) TBL1
|
|
38
36
|
|
|
39
|
-
|
|
37
|
+
JOIN m_staff
|
|
40
38
|
|
|
41
|
-
LEFT JOIN m_staff
|
|
39
|
+
LEFT JOIN tr_attendance ON TBL1.date = date_format(a_clock_in_schedule_date, '%Y.%m.%d') AND m_staff.s_id=tr_attendance.s_id
|
|
42
40
|
|
|
43
|
-
LEFT JOIN tr_attendance ON TBL3.date = date_format(a_clock_in_schedule_date, '%Y.%m.%d') AND TBL3.s_id=tr_attendance.s_id
|
|
44
|
-
|
|
45
|
-
ORDER BY
|
|
41
|
+
ORDER BY m_staff.s_id, TBL1.date;
|
|
46
42
|
|
|
47
43
|
;
|
|
48
44
|
|