Need to select multiple column from multiple tables sum and difference Some help?
select a.naziv as 'Naziv artikla', SUM (cast(a.kolicina as float)) as 'Nabavka', SUM (cast(b.kolicina as float)) as 'Prodaja', b.roba as 'Naziv artikla2' FROM (a.naziv, a.kolicina from ulazni_racun_roba_roba as a union all select a.naziv, a.kolicina from mp_ulazni_racun_ostalo_roba as a union all select b.roba, b.kolicina from mp_racun_roba as b union all select b.roba, b.kolicina from mp_faktura_roba as b) as alltables select (a.kolicina-b.kolicina) as UKUPNO group by naziv
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)