INSTALLMENTPAYMENT

                CREATE view [dbo].[INSTALLMENTPAYMENT]
                as 
                select ISP.PAYMENTID, I.REVENUEID as PLEDGEID, ISPLIT.INSTALLMENTID, sum(ISP.AMOUNT) AMOUNT
                from INSTALLMENTSPLITPAYMENT ISP
                inner join INSTALLMENTSPLIT ISPLIT
                    on ISP.INSTALLMENTSPLITID = ISPLIT.ID
                inner join INSTALLMENT I
                    on ISPLIT.INSTALLMENTID = I.ID
                group by ISP.PAYMENTID, I.REVENUEID, ISPLIT.INSTALLMENTID