Predmet:Re: SQL upiti
Citiraj dex:Napravi prvo View V1
PreuzmiIzvorni 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
PreuzmiIzvorni 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'
Na pocetku sam se i ja sam upustio u vies no problemi su nastali kad sam htio obrisati view sa delete if exist, ili isprazniti tu tablu. To sam rijesio preko admin panela (DROP). Onda sam pomislio koliko bi tek imao problema u php-u tako da sam odustao.
ovo je rezultat tvojeg upita:
name | date Ascending 1 | Id_cityDeparmentOffice | startTime |
Luka | 2020-06-01 | 106 | 11:00:00 |
Luka | 2020-06-01 | 106 | 11:00:00 |
Luka | 2020-06-01 | 106 | 11:00:00 |
Luka | 2020-06-01 | 606 | 11:00:00 |
Luka | 2020-06-01 | 606 | 11:00:00 |
Luka | 2020-06-01 | 606 | 11:00:00 |
Luka | 2020-06-01 | 706 | 12:00:00 |
Luka | 2020-06-01 | 706 | 12:00:00 |
Luka | 2020-06-01 | 706 | 12:00:00 |
Marko | 2020-06-01 | 106 | 17:00:00 |
Marko | 2020-06-01 | 106 | 17:00:00 |
Marko | 2020-06-01 | 106 | 17:00:00 |
Marko | 2020-06-01 | 606 | 17:00:00 |
Marko | 2020-06-01 | 606 | 17:00:00 |
Marko | 2020-06-01 | 606 | 17:00:00 |
Marko | 2020-06-01 | 706 | 18:00:00 |
Marko | 2020-06-01 | 706 | 18:00:00 |
Marko | 2020-06-01 | 706 | 18:00:00 |
Ahmed | 2020-06-02 | 106 | 06:00:00 |
Aleksandar | 2020-06-02 | 106 | 12:00:00 |
Luka | 2020-06-03 | 106 | 18:00:00 |
Aleksandar | 2020-06-03 | 106 | 06:00:00 |
Luka | 2020-06-04 | 106 | 12:00:00 |
Marko | 2020-06-04 | 106 | 18:00:00 |
Ahmed | 2020-06-05 | 106 | 05:30:00 |
Ahmed | 2020-06-05 | 606 | 09:00:00 |
Aleksandar | 2020-06-05 | 106 | 11:30:00 |
Aleksandar | 2020-06-05 | 606 | 15:00:00 |
Aleksandar | 2020-06-06 | 106 | 05:30:00 |
Aleksandar | 2020-06-06 | 106 | 05:30:00 |
Aleksandar | 2020-06-06 | 606 | 09:00:00 |
Aleksandar | 2020-06-06 | 606 | 09:00:00 |
znaci ovo treba ostati nakon upita:
date Ascending 1 | id_employees | id_department | id_office | startTime |
2020-06-01 | 1001 | 10 | 1 | 05:00:00 |
2020-06-01 | 1002 | 310 | 1 | 11:00:00 |
2020-06-01 | 1003 | 610 | 1 | 17:00:00 |
2020-06-02 | 1008 | 30 | 3 | 06:00:00 |
2020-06-02 | 1009 | 330 | 3 | 12:00:00 |
2020-06-02 | 1001 | 630 | 3 | 18:00:00 |
2020-06-03 | 1009 | 30 | 3 | 06:00:00 |
2020-06-03 | 1001 | 330 | 3 | 12:00:00 |
2020-06-03 | 1002 | 630 | 3 | 18:00:00 |
2020-06-04 | 1001 | 30 | 3 | 06:00:00 |
2020-06-04 | 1002 | 330 | 3 | 12:00:00 |
2020-06-04 | 1003 | 630 | 3 | 18:00:00 |
2020-06-05 | 1008 | 20 | 2 | 05:30:00 |
2020-06-05 | 1009 | 320 | 2 | 11:30:00 |
2020-06-05 | 1001 | 620 | 2 | 17:30:00 |
2020-06-06 | 1009 | 20 | 2 | 09:00:00 |
2020-06-06 | 1001 | 320 | 2 | 15:00:00 |
2020-06-07 | 1001 | FD | NULL NULL | |
zivot je moja domovina.
Ovaj post je ureden
1
puta. Posljednja izmjena 10.06.2020 09:39 od strane Avko.