Ovako?
Code:
SELECT
Ulaz.Datum,
Ulaz.Šifra_Ulaz AS Sifra,
Ulaz.Skl,
Ulaz.Ulaz,
0 as BrojOtpremnice,
Ulaz.Predatnica
FROM Ulaz
WHERE (((Ulaz.Ulaz)>0));
Code:
SELECT
Izlazi.Datum,
Izlazi.Sifra_Izlaz AS Sifra,
Izlazi.Skl,
Izlazi.Izlaz,
Izlazi.BrojOtpremnice,
0 as Predatnica
FROM Izlazi
WHERE (((Izlazi.Izlaz)>0));
Code:
SELECT Datum, Skl,Sifra,Ulaz, 0 AS Izlaz, 0 as BrojOtpremnice, Predatnica
FROM 1_qryUlaz
UNION SELECT Datum, Skl,Sifra,0 As Ulaz, Izlaz, BrojOtpremnice, 0 as Predatnica
FROM 2_qryIzlaz;
F