Predmet:Re: SQL upiti
Citiraj Gjoreski:PreuzmiIzvorni kôd (SQL):SELECT *
FROM tbl_calendar t1
INNER JOIN tbl_citydepartmentoffice t2 ON t1.id_cityDepartmentOffice=t2.Id_cityDeparmentOffice
INNER JOIN tbl_schedule t3 ON t2.id_department = t3.id_department
INNER JOIN (SELECT A.DATE,B.id_office,B.id_department
FROM tbl_schedule A
INNER JOIN tbl_citydepartmentoffice B ON B.id_department=A.id_department
WHERE A.id_employees=1001)
tt ON tt.DATE=t3.DATE AND tt.id_department=t2.id_department AND tt.id_office=t2.id_office
Nažalost nije.
Ja sam malo isprobavao. Imam upit za sve employees i sve datume:
PreuzmiIzvorni kôd (Text):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
INNER 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
WHERE r1.date >= DATE('2020-06-01')
ORDER BY r1.date ASC, r1.id_department ASC
limit 0,100;
ako dodam u WHERE AND r1.id_employees=1001, pokaze mi samo za 1001 za sve datume a nevidim druge employeese. Isto tako ne vidim za 7.7. 1001 je FD to mi ne pokaze.
Mozda bi trebalo nesto sa IF THEN ELSE. Ako je id_department > 0 (IsNumeric) onda izvrši upit a ako nije onda neznam.
Zakompliciro sam previše. Ja sam razmisljao da uzmem za Vaska upit pa sa php stavim u array i onda idem od 1 do ubound(array) i pretrazujem za svaki dan po office za ostale. To mi jedino sada pada na pamet.
zivot je moja domovina.
Ovaj post je ureden
1
puta. Posljednja izmjena 08.06.2020 12:35 od strane Avko.