Есть запрос:
/**************************************************
select con.contract_headref head,
con.contract_number conum,
bo.bo_number bonum,
bo.bo_docdate bodate,
kfsr.budgetcodes_code kfsr_key,
kcsr.budgetcodes_code kcsr_key,
kvr.budgetcodes_code kvr_key,
kesr.budgetcodes_code kesr_key,
kvsr.budgetcodes_code kvsr_key,
uecon.budgetcodes_code uecon_key,
ufunc.budgetcodes_code ufunc_key,
comp.companies_fullname compname,
csQ1.contractstages_paymentsum Q1,
csQ2.contractstages_paymentsum Q2,
csQ3.contractstages_paymentsum Q3,
csQ4.contractstages_paymentsum Q4

from contract con
left join bo on (bo.bo_key = con.bo_key)
left join budgetcodes kfsr on (kfsr.budgetcodes_key = con.kfsr_key)
left join budgetcodes kcsr on (kcsr.budgetcodes_key = con.kcsr_key)
left join budgetcodes kvr on (kvr.budgetcodes_key = con.kvr_key)
left join budgetcodes kesr on (kesr.budgetcodes_key = con.kesr_key)
left join budgetcodes kvsr on (kvsr.budgetcodes_key = con.kvsr_key)
left join budgetcodes uecon on (uecon.budgetcodes_key = con.usereconcode_key)
left join budgetcodes ufunc on (ufunc.budgetcodes_key = con.userfunccode_key)
left join companies comp on (comp.companies_key = con.consumer_key)
left join contractstages csQ1 on (bo.bo_key = csQ1.contract_key
and csQ1.contractstages_paymentdate < "01.04.2003")
left join contractstages csQ2 on (bo.bo_key = csQ2.contract_key
and csQ2.contractstages_paymentdate < "01.07.2003")
left join contractstages csQ3 on (bo.bo_key = csQ3.contract_key
and csQ3.contractstages_paymentdate < "01.10.2003")
left join contractstages csQ4 on (bo.bo_key = csQ4.contract_key
and csQ4.contractstages_paymentdate >= "01.10.2003")

where con.contract_iscomplex = 0
and csQ1.rpl_key < 3
and csQ2.rpl_key < 3
and csQ3.rpl_key < 3
and csQ4.rpl_key < 3
and bo.bo_number is not null
group by con.contract_headref,
con.contract_number,
bo.bo_number,
bo.bo_docdate,
kfsr.budgetcodes_code,
kcsr.budgetcodes_code,
kvr.budgetcodes_code,
kesr.budgetcodes_code,
kvsr.budgetcodes_code,
uecon.budgetcodes_code,
ufunc.budgetcodes_code,
comp.companies_fullname,
csQ1.contractstages_paymentsum,
csQ2.contractstages_paymentsum,
csQ3.contractstages_paymentsum,
csQ4.contractstages_paymentsum
order by 12
/**********************************************
Если в таблице нет значения Q1,Q2,Q3 или Q4, либо одного либо нескольких, то запрос выводит строку несколько раз, причём с разными значениями полей. Как сделать так, что если значения нет, то ставить 0, а если есть, то выводить это значение???