Predmet:Re: SQL upiti
evo pogledaj jeli ovo tvoj rezultat
PreuzmiIzvorni kôd (SQL):SELECT * FROM tbl_schedule
INNER JOIN tbl_citydepartmentoffice ON tbl_citydepartmentoffice.id_department=tbl_schedule.id_department
WHERE DATE IN (SELECT DATE
FROM tbl_schedule
INNER JOIN tbl_citydepartmentoffice ON tbl_citydepartmentoffice.id_department=tbl_schedule.id_department
WHERE tbl_schedule.id_employees=1001)
AND id_office IN (SELECT id_office
FROM tbl_schedule
INNER JOIN tbl_citydepartmentoffice ON tbl_citydepartmentoffice.id_department=tbl_schedule.id_department
WHERE tbl_schedule.id_employees=1001) ;