IF (EXISTS (select Table_name from SysTable where LCase(Table_name)=LCase('v_KasaPayment'))) THEN
Drop View v_KasaPayment
END IF

GO

create view  v_KasaPayment as 
SELECT sum(RM.Sum*Cr.ExchangeRate) TotSumL, max(PT.PayTypeName) PTNameL,
RM.Payment
FROM DBA.ResMoney RM, DBA.Currencies Cr, PayTypes PT
WHERE
   RM.Currency = Cr.KodCurrency AND
   RM.DepositNo >= bvrFirstdeposit AND
   RM.DepositNo <= bvrLastdeposit AND
   RM.Payment   =  PT.PayTypeN AND
   RM.InvoiceNo<>''
GROUP BY RM.Payment

union all

SELECT sum(RM.Sum*Cr.ExchangeRate) TotSum, max(PT.PayTypeName) PTName,
 RM.Payment
FROM DBA.ResMoney RM, DBA.Currencies Cr, PayTypes PT
WHERE
   RM.Currency = Cr.KodCurrency AND
   RM.DepositNo >= bvrFirstdeposit AND
   RM.DepositNo <= bvrLastdeposit AND
   RM.Payment   =  PT.PayTypeN AND
   RM.VaucherInvoiceNo<>''
GROUP BY RM.Payment