SELECT tblArtikli.Artikal_Barkod,tblArtikli.Artikal_Ime,(IFNULL(tblLager.Kolicina_Lager,0)-IFNULL(wProdazba.Kolicina,0)) AS Lager,
Artikal_Prodazna_Cena as Cena , (IFNULL(tblLager.Kolicina_Lager,0)-IFNULL(wProdazba.Kolicina,0))*Artikal_Prodazna_Cena AS Vkupno
FROM tblArtikli
LEFT JOIN tblLager
ON tblArtikli.ID_Artikal=tblLager.Artikal
LEFT JOIN wProdazba
ON tblArtikli.ID_Artikal=wProdazba.Stavka
WHERE (IFNULL(tblLager.Kolicina_Lager,0)-IFNULL(wProdazba.Kolicina,0))<>0