dex
Super Moderator
Registrovan od:23.02.2012
Lokacija:Knjazevac
Predmet:
Re: SQL upiti
Napravi prvo View V1
Preuzmi
Izvorni kôd (SQL):
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;
Pa onda
Preuzmi
Izvorni kôd (SQL):
SELECT
V1
.
Name
,
V1
.
DATE
,
V1
.
IDCityDepartmentOffice
,
V1
.
StartTime
FROM
V1
INNER
JOIN
V1
AS
T2
ON
V1
.
DATE
=
T2
.
DATE
AND
V1
.
Office
=
T2
.
IDOffice
AND
V1
.
IDDepartment
=
V1
.
IDDepartment
WHERE
V1
.
name
<>
'Vasko'
AND
T2
.
Name
=
'Vasko'
Ovaj post je ureden
2
puta. Posljednja izmjena 09.06.2020 21:44 od strane dex.