SELECT  rv.id_employees
,r.name
,rv.Date
,rv.id_department
,o.id_office
,CONCAT(k.id_cityDepartmentOffice,rv.id_department) as kljuc
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  o.id_office 
IN (SELECT o.id_office
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