Prikazi cijelu temu
16.11.2012 14:30
16.11.2012 14:30
Predmet:Re: Izračun radnih dana
Q_PlanGO:
SELECT [Prezime] & ", " & [Ime] AS radnik, tblPlanGO.od, tblPlanGO.do, (SELECT Count(Radni) AS Dana
FROM Kalendar
WHERE Datum Between Od And Do AND Praznik=0) AS Dana
FROM Radnici LEFT JOIN tblPlanGO ON Radnici.RadikID = tblPlanGO.IDradnika
Q_PlanGO:
SELECT [Prezime] & ", " & [Ime] AS radnik, tblPlanGO.od, tblPlanGO.do, (SELECT Count(Radni) AS Dana
FROM Kalendar
WHERE Datum Between Od And Do AND Praznik=0) AS Dana
FROM Radnici LEFT JOIN tblPlanGO ON Radnici.RadikID = tblPlanGO.IDradnika
Podrška samo putem foruma, jer samo tako i ostali imaju koristi od toga.