Prikazi cijelu temu 09.06.2020 16:39
Gjoreski Van mreze
Administrator
Registrovan od:02.02.2009
Lokacija:Ohrid Makedonija


Predmet:Re: SQL upiti
PreuzmiIzvorni kôd (SQL):
  1. SELECT r1.DATE, e1.id_employees, r1.id_department, s1.id_office, s1.startTime
  2. FROM tbl_schedule AS r1
  3. INNER JOIN tbl_calendar AS k1 ON r1.DATE = k1.DATE
  4. LEFT JOIN tbl_citydepartmentoffice AS s1 ON (k1.id_cityDepartmentOffice = s1.Id_cityDeparmentOffice AND r1.id_department = s1.id_department)
  5. INNER JOIN tbl_employees AS e1 ON r1.id_employees=e1.id_employees
  6. INNER JOIN (
  7.     SELECT ra1.DATE, ea1.id_employees, ra1.id_department, sa1.id_office, sa1.startTime
  8.     FROM tbl_schedule AS ra1
  9.     INNER JOIN tbl_calendar AS ka1 ON ra1.DATE = ka1.DATE
  10.     LEFT JOIN tbl_citydepartmentoffice AS sa1 ON (ka1.id_cityDepartmentOffice = sa1.Id_cityDeparmentOffice AND ra1.id_department = sa1.id_department)
  11.     INNER JOIN tbl_employees AS ea1 ON ra1.id_employees=ea1.id_employees
  12.     WHERE ea1.id_employees=1001) tUs
  13. ON r1.DATE=tUs.DATE AND s1.id_office=tUs.id_office
  14.  
  15. UNION ALL
  16.  
  17. SELECT r1.DATE, e1.id_employees, r1.id_department, s1.id_office, s1.startTime
  18. FROM tbl_schedule AS r1
  19. INNER JOIN tbl_calendar AS k1 ON r1.DATE = k1.DATE
  20. LEFT JOIN tbl_citydepartmentoffice AS s1 ON (k1.id_cityDepartmentOffice = s1.Id_cityDeparmentOffice AND r1.id_department = s1.id_department)
  21. INNER JOIN tbl_employees AS e1 ON r1.id_employees=e1.id_employees
  22. INNER JOIN (
  23.     SELECT ra1.DATE, ea1.id_employees, ra1.id_department, sa1.id_office, sa1.startTime
  24.     FROM tbl_schedule AS ra1
  25.     INNER JOIN tbl_calendar AS ka1 ON ra1.DATE = ka1.DATE
  26.     LEFT JOIN tbl_citydepartmentoffice AS sa1 ON (ka1.id_cityDepartmentOffice = sa1.Id_cityDeparmentOffice AND ra1.id_department = sa1.id_department)
  27.     INNER JOIN tbl_employees AS ea1 ON ra1.id_employees=ea1.id_employees
  28.     WHERE ea1.id_employees=1001) tUs
  29. ON r1.DATE=tUs.DATE AND e1.id_employees=tUs.id_employees
  30. WHERE ISNULL(s1.id_office) ;