Predmet:Re: SQL upiti
Citiraj zxz:PreuzmiIzvorni kôd (MySQL):
,r.name
,rv.id_department
,o.id_office
,CONCAT(k.id_cityDepartmentOffice
,rv.id_department
) as kljuc
INNER JOIN tbl_citydepartmentoffice
as o
ON o.Id_cityDeparmentOffice
=k.id_cityDepartmentOffice
AND rv.id_department
=o.id_department
INNER JOIN tbl_citydepartmentoffice
as o
ON rv.id_department
=o.id_department
WHERE rv.id_employees
=1001
)
rv.id_employees<>1001
Da budem iskren nisam dovoljno ni procitao.
Gore sam mislio da su prve dvije tabele 1 na 1.
Ovdje je problem kljuca za cetvrtu tabelu i ako je on
IdCityDepartmentOffice i
IdDepartment
onda bi ovo rjesenje trebalo biti dobro.
Nisam testirao.
id_employees | name | Date | id_department | id_office | kljuc | |
1002 | Luka | 2020-06-01 | 310 | 1 | 106310 | |
1003 | Marko | 2020-06-01 | 610 | 1 | 106610 | |
1004 | Ivan | 2020-06-01 | 20 | 2 | 10620 | |
1005 | Marta | 2020-06-01 | 320 | 2 | 106320 | |
1006 | Smiljan | 2020-06-01 | 620 | 2 | 106620 | |
1007 | Mitar | 2020-06-01 | 30 | 3 | 10630 | |
1008 | Ahmed | 2020-06-01 | 330 | 3 | 106330 | |
1009 | Aleksandar | 2020-06-01 | 630 | 3 | 106630 | |
1002 | Luka | 2020-06-02 | 10 | 1 | 10610 | |
1003 | Marko | 2020-06-02 | 310 | 1 | 106310 | |
1004 | Ivan | 2020-06-02 | 610 | 1 | 106610 | |
1005 | Marta | 2020-06-02 | 20 | 2 | 10620 | |
1006 | Smiljan | 2020-06-02 | 320 | 2 | 106320 | |
1007 | Mitar | 2020-06-02 | 620 | 2 | 106620 | |
1008 | Ahmed | 2020-06-02 | 30 | 3 | 10630 | |
1009 | Aleksandar | 2020-06-02 | 330 | 3 | 106330 | |
1002 | Luka | 2020-06-03 | 630 | 3 | 106630 | |
1003 | Marko | 2020-06-03 | 10 | 1 | 10610 | |
1004 | Ivan | 2020-06-03 | 310 | 1 | 106310 | |
1005 | Marta | 2020-06-03 | 610 | 1 | 106610 | |
1006 | Smiljan | 2020-06-03 | 20 | 2 | 10620 | |
1007 | Mitar | 2020-06-03 | 320 | 2 | 106320 | |
1008 | Ahmed | 2020-06-03 | 610 | 1 | 106610 | |
1009 | Aleksandar | 2020-06-03 | 30 | 3 | 10630 | |
1002 | Luka | 2020-06-04 | 330 | 3 | 106330 | |
1003 | Marko | 2020-06-04 | 630 | 3 | 106630 | |
1004 | Ivan | 2020-06-04 | 10 | 1 | 10610 | |
1005 | Marta | 2020-06-04 | 310 | 1 | 106310 | |
1006 | Smiljan | 2020-06-04 | 610 | 1 | 106610 | |
1007 | Mitar | 2020-06-04 | 20 | 2 | 10620 | |
1008 | Ahmed | 2020-06-04 | 320 | 2 | 106320 | |
1009 | Aleksandar | 2020-06-04 | 620 | 2 | 106620 | |
1002 | Luka | 2020-06-05 | 30 | 3 | 10630 | |
1003 | Marko | 2020-06-05 | 330 | 3 | 106330 | |
1004 | Ivan | 2020-06-05 | 630 | 3 | 106630 | |
1005 | Marta | 2020-06-05 | 10 | 1 | 10610 | |
1006 | Smiljan | 2020-06-05 | 310 | 1 | 106310 | |
1007 | Mitar | 2020-06-05 | 610 | 1 | 106610 | |
1008 | Ahmed | 2020-06-05 | 20 | 2 | 10620 | |
1009 | Aleksandar | 2020-06-05 | 320 | 2 | 106320 | |
1006 | Smiljan | 2020-06-06 | 10 | 1 | 60610 | |
1007 | Mitar | 2020-06-06 | 310 | 1 | 606310 | |
1008 | Ahmed | 2020-06-06 | 610 | 1 | 606610 | |
1009 | Aleksandar | 2020-06-06 | 20 | 2 | 60620 | |
1007 | Mitar | 2020-06-07 | 10 | 1 | 70610 | |
1008 | Ahmed | 2020-06-07 | 310 | 1 | 706310 | |
1009 | Aleksandar | 2020-06-07 | 610 | 1 | 706610 | |
Pokazuje sve osim Vasko 1001, nije ni točno.
ovako bi trebalo izgledati:
date | id_employees | name | id_department | id_office | startTime | |
2020-06-01 | 1001 | Vasko | 10 | 1 | 05:00:00 | |
2020-06-01 | 1002 | Luka | 310 | 1 | 11:00:00 | |
2020-06-01 | 1003 | Marko | 610 | 1 | 17:00:00 | |
2020-06-02 | 1008 | Ahmed | 30 | 3 | 06:00:00 | |
2020-06-02 | 1009 | Aleksandar | 330 | 3 | 12:00:00 | |
2020-06-02 | 1001 | Vasko | 630 | 3 | 18:00:00 | |
2020-06-03 | 1009 | Aleksandar | 30 | 3 | 06:00:00 | |
2020-06-03 | 1001 | Vasko | 330 | 3 | 12:00:00 | |
2020-06-03 | 1002 | Luka | 630 | 3 | 18:00:00 | |
2020-06-04 | 1001 | Vasko | 30 | 3 | 06:00:00 | |
2020-06-04 | 1002 | Luka | 330 | 3 | 12:00:00 | |
2020-06-04 | 1003 | Marko | 630 | 3 | 18:00:00 | |
2020-06-05 | 1008 | Ahmed | 20 | 2 | 05:30:00 | |
2020-06-05 | 1009 | Aleksandar | 320 | 2 | 11:30:00 | |
2020-06-05 | 1001 | Vasko | 620 | 2 | 17:30:00 | |
2020-06-06 | 1009 | Aleksandar | 20 | 2 | 09:00:00 | |
2020-06-06 | 1001 | Vasko | 320 | 2 | 15:00:00 | |
2020-06-07 | 1001 | Vasko | FD | | | |
zivot je moja domovina.