回答編集履歴
1
SQL文修正
answer
CHANGED
|
@@ -23,7 +23,7 @@
|
|
|
23
23
|
MIN(TestWorkIn.TimeStamp) WorkIn
|
|
24
24
|
MAX(TestWorkOut.TimeStamp) WorkOut,
|
|
25
25
|
MIN(TestRestIn.TimeStamp) RestIn,
|
|
26
|
-
|
|
26
|
+
MAX(TestRestOut.TimeStamp) RestOut
|
|
27
27
|
From Test
|
|
28
28
|
LEFT JOIN Test AS TestWorkIn ON TestWorkIn.Name=Test.Name AND TestWorkIn.TimeDate=Test.TimeDate AND TestWorkIn.TimeKind='a'
|
|
29
29
|
LEFT JOIN Test AS TestWorkOut ON TestWorkOut.Name=Test.Name AND TestWorkOut.TimeDate=Test.TimeDate AND TestWorkOut.TimeKind='b'
|