SELECT * FROM tbl_schedule
INNER JOIN tbl_citydepartmentoffice ON tbl_citydepartmentoffice.id_department=tbl_schedule.id_department
WHERE date IN (SELECT date
               FROM tbl_schedule
               INNER JOIN tbl_citydepartmentoffice ON tbl_citydepartmentoffice.id_department=tbl_schedule.id_department
               WHERE tbl_schedule.id_employees=1001)
AND id_office IN (SELECT id_office
                  FROM tbl_schedule
                  INNER JOIN tbl_citydepartmentoffice ON tbl_citydepartmentoffice.id_department=tbl_schedule.id_department
                  WHERE tbl_schedule.id_employees=1001) ;