Predmet:Re: SQL upiti

---

1.6. Vasko 1001 radi u idDepartment 10, a idDepartment 10 za 1.6. je office 1. Vasko radi od 5:00 do 11:00
Tko još radi u office 1 za 1.6.?
Za 1.6. u office 1 još radi:
-1002 od 11:00 do 17:00
-1003 od 17:00 do 23:00

za 2.6.:

Vasko ima idDepartment 630
U tblCalendar za 2.6. IdCityDepartmentOffice je 0106

idDepartment 630 + idCityDepartmentOffice 0106 => idOffice 3

Tko ima idOffice 3 za date 2.6. ?

tblCalendar za 2.6. je idCityDepartmentOffice 0106

u tblCityDepartmentOffice za office 3 i idCitiDepatmentOffice 0106 => idDepartment 30 i idDepartment 330

Tko ima za 2.6. idDepartment 30 i idDepartment 330 ?

u tblSchedule idDepartment 30 i idDepartment 330 za 2.6. imaju employment 1008 i 1009

itd

---