SELECT  r.name
,rv.Date
,rv.id_department
,CONCAT(rv.id_department,rv.Date) as kljuc
FROM tbl_schedule 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
WHERE  CONCAT(rv.id_department,rv.Date) 
IN (SELECT 
CONCAT(rv.id_department,rv.Date) as kljuc
FROM tbl_schedule as rv WHERE id_employees=1001
)
AND
rv.id_employees<>1001