SELECT c.PERSONID,count(CALENDARDATE) AS ‘workdays’ | |
---|---|
FROM ATDADJUSTTIMEORDER c | |
INNER JOIN (select * from AtdTimeOrderCalendar where CALENDARDATE BETWEEN ‘2023-07-01’ AND ‘2023-09-30’) d ON d.TIMEORDERID=c.TIMEORDERID | |
INNER JOIN psnaccount p3 ON p3.PERSONID=c.PERSONID | |
WHERE d.CALENDARDATE>=p3.attendondate | |
AND BEGINDATE <= ‘2023-07-01’ AND c.ENDDATE>= ‘2023-09-30’ | |
AND d.CALENDARDATE<=p3.DIMISSIONDATE | |
AND d.CALENDARTYPE=1 | |
GROUP BY personid |