本文介绍了您尝试执行查询而不是聚合函数的一部分的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
SELECT a.staff,a.logiodate,a.LogInTime,a.LogOutTime,a.nodeid
FROM (SELECT NGAC_USERINFO.username AS Staff, Int([Logtime]) AS LogIODate, Format(Min(NGAC_LOG.logtime),"h:m:s") AS LogInTime, Format(Max(NGAC_LOG.logtime),"h:m:s") AS LogOutTime,nodeid
FROM NGAC_LOG INNER JOIN NGAC_USERINFO ON NGAC_LOG.userid = NGAC_USERINFO.userid WHERE ( NGAC_LOG.nodeid=1 AND ((Int([logtime])) Between #21/09/2016# And #21/09/2016 23:59:59#))
GROUP BY NGAC_USERINFO.username, NGAC_LOG.Userid, Int([Logtime]), Int([Logtime]), nodeid ) AS A
INNER JOIN NGAC_TERMINAL ON A.nodeid=NGAC_TERMINAL.nodeid
group by staff,logiodate,LogInTime,LogOutTime,a.nodeid
having LogInTime>'9:45:00'
我的尝试:
亲切帮助
提前感谢
What I have tried:
kindly help
thanks in advance
推荐答案
这篇关于您尝试执行查询而不是聚合函数的一部分的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!