Prikazi cijelu temu 09.06.2020 21:11
dex Van mreze
Super Moderator
Registrovan od:23.02.2012
Lokacija:Knjazevac


Predmet:Re: SQL upiti
Napravi prvo View V1
PreuzmiIzvorni kôd (SQL):
  1. CREATE VIEW V1 AS
  2. SELECT tblEmployees.Name, tblSchedule.DATE, tblCityDepartmentOffice.IDOffice,
  3.  tblCityDepartmentOffice.IDDepartment, tblCityDepartmentOffice.IDCityDepartmentOffice,
  4.  tblCityDepartmentOffice.StartTime
  5. FROM (tblEmployees INNER JOIN tblSchedule
  6. ON tblEmployees.IDEmployees = tblSchedule.IDEmployees)
  7. INNER JOIN tblCityDepartmentOffice
  8. ON tblSchedule.IDDepartment = tblCityDepartmentOffice.IDDepartment;

Pa onda

PreuzmiIzvorni kôd (SQL):
  1. SELECT V1.Name, V1.DATE, V1.IDCityDepartmentOffice, V1.StartTime FROM V1
  2. INNER JOIN V1 AS T2
  3. ON V1.DATE = T2.DATE
  4. AND  V1.Office = T2.IDOffice AND V1.IDDepartment = V1.IDDepartment
  5. WHERE V1.name <> 'Vasko' AND T2.Name = 'Vasko'
Ovaj post je ureden 2 puta. Posljednja izmjena 09.06.2020 21:44 od strane dex.