Create View V1 AS SELECT tblEmployees.Name, tblSchedule.Date, tblCityDepartmentOffice.IDOffice, tblCityDepartmentOffice.IDDepartment, tblCityDepartmentOffice.IDCityDepartmentOffice, tblCityDepartmentOffice.StartTime FROM (tblEmployees INNER JOIN tblSchedule ON tblEmployees.IDEmployees = tblSchedule.IDEmployees) INNER JOIN tblCityDepartmentOffice ON tblSchedule.IDDepartment = tblCityDepartmentOffice.IDDepartment;