Prikazi cijelu temu 07.06.2020 18:36
Gjoreski Van mreze
Administrator
Registrovan od:02.02.2009
Lokacija:Ohrid Makedonija


Predmet:Re: SQL upiti
evo pogledaj jeli ovo tvoj rezultat

PreuzmiIzvorni kôd (SQL):
  1. SELECT * FROM tbl_schedule
  2. INNER JOIN tbl_citydepartmentoffice ON tbl_citydepartmentoffice.id_department=tbl_schedule.id_department
  3. WHERE DATE IN (SELECT DATE
  4.                FROM tbl_schedule
  5.                INNER JOIN tbl_citydepartmentoffice ON tbl_citydepartmentoffice.id_department=tbl_schedule.id_department
  6.                WHERE tbl_schedule.id_employees=1001)
  7. AND id_office IN (SELECT id_office
  8.                   FROM tbl_schedule
  9.                   INNER JOIN tbl_citydepartmentoffice ON tbl_citydepartmentoffice.id_department=tbl_schedule.id_department
  10.                   WHERE tbl_schedule.id_employees=1001) ;