Add to one table mssql

Question

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 UL. roba ULR. ostalo UL. Repromaterijal Saldo
MOZZART DOO 630.20 93.60 292.50 1016.30

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?

Mohit Vijay · Answer

Hi, If I understand your question correctly, you don't want to show the table, if the result does not exist for that partner. You have to apply a check on the select query, if the count is >0 then execute the select statement with the result. But in this case. the overall query will become slow. Thanks, Mohit

Goran Bibic · Answer

My query result If remove two columns x2.poslovni_partner, x3 .poslovni_partner i have this report Must not be null...need to be name of partner (see on another picture near on number 23) I need some value...if put x2.poslovni_partner= x1.poslovni_partner I just have value where have same value in column x1.poslovni_partne and x2.poslovni_partner. Some help??