Sum column from multiple tables and diff sql

Goran Bibic

8y942SQL

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

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Goran Bibic8y ago
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)))
0
Goran Bibic8y ago
Msg 102, Level 15, State 1, Line 6
Incorrect syntax near ','.
Msg 102, Level 15, State 1, Line 17
Incorrect syntax near ')'.
0
Shahriar Nikkhah8y ago
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
+1
Shahriar Nikkhah8y ago
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
+1