Predmet:Re: SQL upiti
Ja opet ne razumem nista sve radim napamet.
Mozemo li ovako:
Prvo uradi cu jedan sql koj ce nam iscitati sve zapise koje nam trebaju a kasnije cemo dodati uslov,evo SQL pogledaj jel ima on sve podatke koje nam trebaju ?
PreuzmiIzvorni kôd (SQL):SELECT r1.DATE, e1.id_employees, r1.id_department, s1.id_office, s1.startTime
FROM tbl_schedule AS r1
INNER JOIN tbl_calendar AS k1 ON r1.DATE = k1.DATE
LEFT JOIN tbl_citydepartmentoffice AS s1 ON (k1.id_cityDepartmentOffice = s1.Id_cityDeparmentOffice AND r1.id_department = s1.id_department)
INNER JOIN tbl_employees AS e1 ON r1.id_employees=e1.id_employees