employee attendance query

I Have 3 tables
dbo.Emp_setting
name data type allownulls Empset_id int Unchecked personal_id int Unchecked DesignationID int Checked DivisionID int Checked Emp_status char(1) Checked Emp_TypeId int Checked Dept_Id int Checked Group_Id int Checked NDIVGRP_CODE bigint Checked dbo.tempDeviceLogs
name datatype allow nulls LogsID int Unchecked Device_Pe ...