Hello guys is there any way on where can i execute my query faster ? here it us:
What I have tried:
select count(distinct(str_to_date(dwardate,'%m/%d/%Y'))) as tdays ,staffhouse,mealallowance,transporallowance " & _
",staffhouseto,mealto,transpoto,transpoeffective From employees " & _
"inner join EAC on eac.employeesid = employees.employeesid " & _
"inner join tbldwardetails on tbldwardetails.Employeesid = employees.employeesID " & _
"Inner join employeesAttendance on employeesAttendance.Employeesid = employees.employeesID " & _
"WHERE LOGTIMEIN <> '' AND LOGTIMEOUT<> '' AND Remarked <> 'OFFSET FROM' AND str_to_date(dwardate,'%m/%d/%Y') >= '" & dafrom & "' and str_to_date(dwardate,'%m/%d/%Y') <= '" & dato & "' and EMPLOYEES.employeesid = " & empids & " group by dwardate"