Help to have a look at why would an error-CodePudding

 
Select distinct EmployeeID, realtimes=count (1), MonthIntTime 
(
Select the left (the convert (varchar (100), RealTime, 112), 6) as MonthIntTime, 
Left (the convert (varchar (90), RealTime, 108), 5) as realtimes, 
EmployeeID=(select distinct EmployeeID from openjson (GroupDetail) with (EmployeeID uniqueidentifier $. 'EmployeeID')) from Device_IoTData 
) a 
The join Basic_Employee be on be. Id=a.E mployeeID 
Where arjun onthIntTime=202006 and be id=a.E mployeeID and a.r ealtimes>='08:00 and a.r ealtimes
='16:00'

CodePudding user response:

Select distinct EmployeeID, realtimes=count (1), MonthIntTime
from

) a
The join...

CodePudding user response:

1/f, right, a table without the From outside