Prikazi cijelu temu 09.06.2020 19:54
zxz Van mreze
Administrator
Registrovan od:03.02.2009
Lokacija:Tuzla


Predmet:Re: SQL upiti
Ti trazis ovo rjesenje ali ovo rjesenje nije tacno po meni.
PreuzmiIzvorni kôd (Text):
  1. SELECT  rv.Date
  2. ,rv.id_employees
  3. ,r.name
  4.  
  5. ,rv.id_department
  6. ,o.id_office
  7. ,o.startTime
  8. FROM tbl_schedule as rv
  9. INNER JOIN tbl_employees  as r ON rv.id_employees=r.id_employees
  10. INNER JOIN tbl_calendar as k   ON k.date=rv.date
  11. INNER JOIN tbl_citydepartmentoffice as o   ON o.Id_cityDeparmentOffice=k.id_cityDepartmentOffice
  12. AND rv.id_department=o.id_department
  13. WHERE  CONCAT(o.id_office,rv.Date)
  14. IN (SELECT CONCAT(o.id_office,rv.Date) as kljuc
  15. FROM tbl_schedule as rv
  16. INNER JOIN tbl_citydepartmentoffice as o   ON rv.id_department=o.id_department
  17. WHERE rv.id_employees=1001
  18. )
  19. AND
  20. rv.id_employees<>1001

evo zasto nije tacno.
grad
---------
id grad
id kancelarija
id zgrada

kancelarija jeste ista ali nije u istom gradu i u istoj zgradi-
Podrška samo putem foruma, jer samo tako i ostali imaju koristi od toga.