Predmet:Re: SQL upiti
Ti trazis ovo rjesenje ali ovo rjesenje nije tacno po meni.
PreuzmiIzvorni kôd (Text):SELECT rv.Date
,rv.id_employees
,r.name
,rv.id_department
,o.id_office
,o.startTime
FROM tbl_schedule as rv
INNER JOIN tbl_employees as r ON rv.id_employees=r.id_employees
INNER JOIN tbl_calendar as k ON k.date=rv.date
INNER JOIN tbl_citydepartmentoffice as o ON o.Id_cityDeparmentOffice=k.id_cityDepartmentOffice
AND rv.id_department=o.id_department
WHERE CONCAT(o.id_office,rv.Date)
IN (SELECT CONCAT(o.id_office,rv.Date) as kljuc
FROM tbl_schedule as rv
INNER JOIN tbl_citydepartmentoffice as o ON rv.id_department=o.id_department
WHERE rv.id_employees=1001
)
AND
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.