Sum column from multiple tables and diff sql

Question

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

Shahriar Nikkhah · Answer

OOPS i forgt you can not use the letters "a" , "b" , "c" in lines 1,2 and 3 you must use the word "alltables" insted fix the query and lets see what you are looking for

Shahriar Nikkhah · Answer

The question is not clear and youre query is not correct and needs to be fixed first Line 06 you are missing a SELECT Line 19 You can't have SELECT between a FROM and a GROUP BY ????? Please fixed them first and then give more info so that we can 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

Goran Bibic · Answer

1)I need a.naziv, a.kolicina(a.naziv as 'Naziv artikla', SUM (cast(a.kolicina as float)) as 'Nabavka') from table ulazni_racun_roba_roba and mp_ulazni_racun_ostalo_roba (to be first and second datagrid column groub by naziv) 2) b.roba nad b.kolicina (SUM (cast(b.kolicina as float)) as 'Prodaja', b.roba as 'Naziv artikla2') from tables mp_racun_roba and mp_faktura_roba (third datagrid column) becose a.naziv=b.roba 3) DIFF( Column NABAVKA-Column PRODAJA ( in Column foor (TOTAL)))

Goran Bibic · Answer

Msg 102, Level 15, State 1, Line 6 Incorrect syntax near ','. Msg 102, Level 15, State 1, Line 17 Incorrect syntax near ')'.