SELECT *
FROM tbl_calendar t1
INNER JOIN tbl_citydepartmentoffice t2 ON t1.id_cityDepartmentOffice=t2.Id_cityDeparmentOffice
INNER JOIN tbl_schedule t3 ON t2.id_department = t3.id_department
INNER JOIN (SELECT A.DATE,B.id_office,B.id_department
FROM tbl_schedule A
INNER JOIN tbl_citydepartmentoffice B ON B.id_department=A.id_department
WHERE A.id_employees=1001)
tt ON tt.DATE=t3.DATE AND tt.id_department=t2.id_department AND tt.id_office=t2.id_office