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'