Untitled
unknown
mysql
a year ago
317 B
10
Indexable
SELECT
name, division, t.intime, t.outtime
FROM
(SELECT
employeeid, MIN(timein) AS InTime, MAX(timeout) AS OutTime
FROM
timelog
WHERE
division = '7217'
AND DATE(timein) >= CURDATE()
GROUP BY employeeid) t
JOIN employee e ON e.id = t.employeeidEditor is loading...
Leave a Comment