SELECT
g.Name as [Гарантия],
ap.OGRNIP as [ОГРН фирмы],
ap.INN as [ИНН фирмы],
g.CreationDate as [Дата получения заявки],
ap.RegistrationDate as [Дата регистрации фирмы],
cus.CodeSubjectCreditHistory as [Регион клиента],
gt.Name as [Подтип контракта],
g.Number as [Номер],
cus.Name as [Наименвоание бенефициара],
cus.OGRNIP as [ОГРН бенефициара],
cus.INN as [ИНН бенефиуиара],
cus.CodeSubjectCreditHistory as [Регион исполнения контракта],

g.ContractSum as [Сумма контракта],
g.CountOfWorkedDays as [Срок гарантии],
tf.Name as [Система налогообложения принципала]



FROM RequestBankGuarantee g
left join TaxForm tf on g.TaxForm=tf.Id
left join SubjectMSP ap on g.Applicant=ap.Id
left join GuaranteeType gt on g.Type=gt.Id
left join SubjectMSP cus on g.Customer=cus.Id

inner join M_RBG_ReportingAndMetrics rm on g.Id=rm.Parent
left join RequestGuaranteePage rp on rm.Child=rp.id
left join ReportingGroup rg on rg.Id=rp.MainGroup


--select * from Agent

--select * from RequestBankGuarantee

--select * from GuaranteeType



--select * from ReportingGroup