Izvini ali moram reći da si prilično nekooperativan u situaciji gdje ti treba pomoć i drugi se trude da ti pomognu.
Kreirao sam sve u Accessu i kod mene radi tako da si vjerovatno pogriješio u kopiranju i ispravljanju SQL upita.
nalozi
Code:
vremepocetka vremekraja
09:00:00 10:00:00
12:00:00 12:30:00
sati
Code:
satod satdo
08:00:00 20:00:00
sql upit
Code:
SELECT * FROM
(
SELECT
t.vremekraja AS pocetak,
(
SELECT MIN(t2.vremepocetka)
FROM nalozi as t2
WHERE t2.vremepocetka >= t.vremekraja
) AS kraj
FROM nalozi as t
UNION
SELECT
(SELECT MIN(satod) FROM sati) AS pocetak,
MIN(vremepocetka) AS kraj
FROM nalozi
UNION
SELECT
MAX(vremekraja) AS pocetak,
(SELECT MIN(satdo) FROM sati) AS kraj
FROM nalozi
)
WHERE pocetak < kraj
ORDER BY pocetak
rezultat upita
Code:
pocetak kraj
08:00:00 09:00:00
10:00:00 12:00:00
12:30:00 20:00:00