Prikazi cijelu temu 09.06.2020 09:28
Avko Van mreze
Administrator
Registrovan od:28.05.2014
Lokacija:zagreb


Predmet:Re: SQL upiti
Citiraj Gjoreski:
Ja opet ne razumem nista sve radim napamet.

Mozemo li ovako:
Prvo uradi cu jedan sql koj ce nam iscitati sve zapise koje nam trebaju a kasnije cemo dodati uslov,evo SQL pogledaj jel ima on sve podatke koje nam trebaju ?

PreuzmiIzvorni kôd (SQL):
  1. SELECT r1.DATE, e1.id_employees, r1.id_department, s1.id_office, s1.startTime
  2. FROM tbl_schedule AS r1
  3. INNER JOIN tbl_calendar AS k1 ON r1.DATE = k1.DATE
  4. LEFT JOIN tbl_citydepartmentoffice AS s1 ON (k1.id_cityDepartmentOffice = s1.Id_cityDeparmentOffice AND r1.id_department = s1.id_department)
  5. INNER JOIN tbl_employees AS e1 ON r1.id_employees=e1.id_employees

evo ištitalo je sve:

dateid_employeesnameid_departmentid_officestartTime 
2020-06-011001Vasko10105:00:00 
2020-06-021002Luka10105:00:00 
2020-06-031003Marko10105:00:00 
2020-06-041004Ivan10105:00:00 
2020-06-051005Marta10105:00:00 
2020-06-011004Ivan20205:30:00 
2020-06-021005Marta20205:30:00 
2020-06-031006Smiljan20205:30:00 
2020-06-041007Mitar20205:30:00 
2020-06-051008Ahmed20205:30:00 
2020-06-041001Vasko30306:00:00 
2020-06-051002Luka30306:00:00 
2020-06-011007Mitar30306:00:00 
2020-06-021008Ahmed30306:00:00 
2020-06-031009Aleksandar30306:00:00 
2020-06-011002Luka310111:00:00 
2020-06-021003Marko310111:00:00 
2020-06-031004Ivan310111:00:00 
2020-06-041005Marta310111:00:00 
2020-06-051006Smiljan310111:00:00 
2020-06-011005Marta320211:30:00 
2020-06-021006Smiljan320211:30:00 
2020-06-031007Mitar320211:30:00 
2020-06-041008Ahmed320211:30:00 
2020-06-051009Aleksandar320211:30:00 
2020-06-031001Vasko330312:00:00 
2020-06-041002Luka330312:00:00 
2020-06-051003Marko330312:00:00 
2020-06-011008Ahmed330312:00:00 
2020-06-021009Aleksandar330312:00:00 
2020-06-011003Marko610117:00:00 
2020-06-021004Ivan610117:00:00 
2020-06-031005Marta610117:00:00 
2020-06-041006Smiljan610117:00:00 
2020-06-051007Mitar610117:00:00 
2020-06-031008Ahmed610117:00:00 
2020-06-051001Vasko620217:30:00 
2020-06-011006Smiljan620217:30:00 
2020-06-021007Mitar620217:30:00 
2020-06-041009Aleksandar620217:30:00 
2020-06-021001Vasko630318:00:00 
2020-06-031002Luka630318:00:00 
2020-06-041003Marko630318:00:00 
2020-06-051004Ivan630318:00:00 
2020-06-011009Aleksandar630318:00:00 
2020-06-061006Smiljan10105:00:00 
2020-06-061009Aleksandar20209:00:00 
2020-06-061007Mitar310111:00:00 
2020-06-061001Vasko320215:00:00 
2020-06-061008Ahmed610117:00:00 
2020-06-071007Mitar10106:00:00 
2020-06-071008Ahmed310112:00:00 
2020-06-071009Aleksandar610118:00:00 
2020-06-071001VaskoFDNULL    NULL  
2020-06-061002LukaFDNULL    NULL  
2020-06-071002LukaFDNULL    NULL  
2020-06-061003MarkoFDNULL    NULL  
2020-06-071003MarkoFDNULL    NULL  
2020-06-061004IvanFDNULL    NULL  
2020-06-071004IvanFDNULL    NULL  
2020-06-061005MartaFDNULL    NULL  
2020-06-071005MartaFDNULL    NULL  
2020-06-071006SmiljanFDNULL    NULL  
zivot je moja domovina.