Select from multiple tables

Question

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