PreuzmiIzvorni kôd (Text):

1. SELECT  r.name
2. ,rv.Date
3. ,rv.id_department
4. ,CONCAT(rv.id_department,rv.Date) as kljuc
5. FROM tbl_schedule rv
6. INNER JOIN tbl_employees  as r ON rv.id_employees=r.id_employees
7. WHERE  CONCAT(rv.id_department,rv.Date)
8. IN (SELECT
9. CONCAT(rv.id_department,rv.Date) as kljuc
10. FROM tbl_schedule as rv WHERE id_employees=1001
11. )
12. AND
13. rv.id_employees<>1001

pod uslovom da sam pogodio polje broj kancelarija.
U mom slucaju je to id_department