Add to one table mssql

My code is

select x1.poslovni_partner,
CONVERT(decimal(16,2),(ISNULL(x1.ULR,0))) AS 'UL. roba',
CONVERT(decimal(16,2),(ISNULL(x2.ULRO, 0))) as 'ULR. ostalo',
CONVERT(decimal(16,2),(ISNULL(x3.ULRM, 0))) as 'UL. Repromaterijal',
CONVERT(decimal(16, 2), (ISNULL(ULR, 0) + (ISNULL(ULRO, 0) + (ISNULL(ULRM, 0))))) as 'Saldo'
from (select poslovni_partner, sum(iznos_sa_porezom) as ULR from(select poslovni_partner as poslovni_partner, iznos_sa_porezom from dbo.mp_ulazni_racun_roba_lista where redni_broj IS NOT NULL) a group by poslovni_partner) as x1 JOIN
(select poslovni_partner, sum(iznos_sa_porezom) as ULRO from (select poslovni_partner as poslovni_partner,iznos_sa_porezom from dbo.mp_ulazni_racun_ostalo_lista where redni_broj IS NOT NULL) b group by poslovni_partner) as x2 on x1.poslovni_partner = x2.poslovni_partner JOIN
(select poslovni_partner, sum(iznos_sa_porezom) as ULRM from (select poslovni_partner as poslovni_partner,iznos_sa_porezom from dbo.mp_ulazni_racun_repromaterijal_lista where redni_broj IS NOT NULL) b group by poslovni_partner) as x3 on x1.poslovni_partner = x3.poslovni_partner

Result is

poslovni_partner is bussines partner on english

Need for all partners in this 3 tables.

Result is IF have partners in all tables...if not exist i one of tables dont show him...

If not exist in one table need to show 0.00

some help please?

2 Replies

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