Evo koda na kome radim
Stalno dobijam nulu kao rezultat. Ne znam u cemu gresim
Code:
SELECT nz(sum(table1.PDV1),0)- nz(sum(table2.PDV2),0) AS Sum
FROM table1 inner join table2 ON table1.id1=table2.id1
WHERE table1.date>= #1/1/2013# and table1.date<=#30/4/2013#
SELECT nz(sum(table1.PDV1),0)- nz(sum(table2.PDV2),0) AS Sum
FROM table1 inner join table2 ON table1.id1=table2.id1
WHERE table1.date>= #1/1/2013# and table1.date<=#30/4/2013#
Stalno dobijam nulu kao rezultat. Ne znam u cemu gresim