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
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