Select from multiple tables

Goran Bibic

6y847SQL

Regard

select x1.sifra as 'Šifra', x1.naziv as Naziv, x2.naziv as Naziv, x2.sifra as 'Šifra'
FROM(select naziv, sifra, sum(ISNULL(kolicina, 0)) as Prodaja
from(select roba as naziv, sifra, sum(ISNULL(kolicina, 0)) as kolicina from mp_racun_roba group by roba, sifra )b
group by naziv, sifra, kolicina) x1
FULL OUTER JOIN
(select naziv, sifra, sum(ISNULL(kolicina, 0)) as Nabavka
from( select naziv, sifra, sum(ISNULL(kolicina, 0)) as kolicina from dbo.mp_ulazni_racun_roba_roba WHERE id_fakture IN
(SELECT id FROM dbo.mp_ulazni_racun_roba_lista WHERE magacin = 'Magacin robe maloprodaja') group by naziv, sifra) a
group by naziv, sifra) x2
on x1.sifra=x2.sifra
group by x1.naziv, x1.sifra, x2.sifra,x2.naziv

Result

I need two column, first and second...if change code...

select x1.sifra as 'Šifra', x1.naziv as Naziv
FROM(select naziv, sifra, sum(ISNULL(kolicina, 0)) as Prodaja
from(select roba as naziv, sifra, sum(ISNULL(kolicina, 0)) as kolicina from mp_racun_roba group by roba, sifra )b
group by naziv, sifra, kolicina) x1
FULL OUTER JOIN
(select naziv, sifra, sum(ISNULL(kolicina, 0)) as Nabavka
from( select naziv, sifra, sum(ISNULL(kolicina, 0)) as kolicina from dbo.mp_ulazni_racun_roba_roba WHERE id_fakture IN
(SELECT id FROM dbo.mp_ulazni_racun_roba_lista WHERE magacin = 'Magacin robe maloprodaja') group by naziv, sifra) a
group by naziv, sifra) x2
on x1.sifra=x2.sifra
group by x1.naziv, x1.sifra

Need and first row to be code (Šifra) and name (Naziv)

Advice?

Where I wrong?

Thank you

2 Replies

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

Goran Bibic6y ago
On code
select x1.sifra as 'Code(Šifra)', x1.naziv as   'Name(naziv)'
FROM(select naziv, sifra, sum(ISNULL(kolicina, 0)) as Prodaja
from(select roba as naziv, sifra, sum(ISNULL(kolicina, 0)) as kolicina from mp_racun_roba group by roba, sifra )b
group by naziv, sifra, kolicina) x1
FULL OUTER JOIN
(select naziv, sifra, sum(ISNULL(kolicina, 0)) as Nabavka
from( select naziv, sifra, sum(ISNULL(kolicina, 0)) as kolicina from dbo.mp_ulazni_racun_roba_roba WHERE id_fakture IN
(SELECT id FROM dbo.mp_ulazni_racun_roba_lista WHERE magacin = 'Magacin robe maloprodaja') group by naziv, sifra) a
group by naziv, sifra) x2
on x1.sifra=x2.sifra
group by x1.naziv, x1.sifra
Vinay Singh6y ago
You question is not much clear. But still as per my understanding please check the query just replace the below in ur query
select x1.sifra as 'Code(Šifra)', x1.naziv as 'Name(naziv)'