Task

--в этом конкретном случае сбор оплат за 12 месяцев по старым договорам в 21 году

select offi.name, bud.name,mt.money_type,sum(payment) as summa from (
select * from com_jur2021..payment_a where number in (select id from com_jur_calc..contracts_to_identifier where (YEAR<2021 or begin_date is null))
union
select * from com_jur2021..payment_t where number in (select id from com_jur_calc..contracts_to_identifier where (YEAR<2021 or begin_date is null))
--and month < 10
) pay
left join com_jur_spr..offices offi on pay.id_office = offi.id
left join com_jur_spr..money_type mt on pay.money = mt.id
left join com_jur_spr..budget_organizations borg on pay.id_organization = borg.id_organization
left join com_jur_spr..budgets bud on borg.id_budget = bud.id
group by offi.name, bud.name,mt.money_type
order by offi.name, bud.name,mt.money_type

---------------------за первый квартал 2022

select offi.name, bud.name,mt.money_type,sum(payment) as summa from (
select * from com_jur2022..payment_a where number in (select id from com_jur_calc..contracts_to_identifier where (YEAR<2022 or begin_date is null))
--union
--select * from com_jur2022..payment_t where number in (select id from com_jur_calc..contracts_to_identifier where (YEAR<2022 or begin_date is null))
and month < 4
) pay
left join com_jur_spr..offices offi on pay.id_office = offi.id
left join com_jur_spr..money_type mt on pay.money = mt.id
left join com_jur_spr..budget_organizations borg on pay.id_organization = borg.id_organization
left join com_jur_spr..budgets bud on borg.id_budget = bud.id
group by offi.name, bud.name,mt.money_type
order by offi.name, bud.name,mt.money_type