SELECT  rv.Date
,rv.id_employees
,r.name

,rv.id_department
,o.id_office
,o.startTime
FROM tbl_schedule as rv
INNER JOIN tbl_employees  as r ON rv.id_employees=r.id_employees
INNER JOIN tbl_calendar as k   ON k.date=rv.date
INNER JOIN tbl_citydepartmentoffice as o   ON o.Id_cityDeparmentOffice=k.id_cityDepartmentOffice
AND rv.id_department=o.id_department
WHERE  CONCAT(o.id_office,rv.Date)
IN (SELECT CONCAT(o.id_office,rv.Date) as kljuc
FROM tbl_schedule as rv
INNER JOIN tbl_citydepartmentoffice as o   ON rv.id_department=o.id_department
WHERE rv.id_employees=1001
) 
AND
rv.id_employees<>1001