Alan

CREATE VIEW [dbo].[VW2]
WITH SCHEMABINDING
AS
SELECT        dbo.CharityTbl.CharityID, dbo.CharityTbl.CharityName, dbo.CharityTbl.CharityRegisteresedOffice, SUM(ISNULL(dbo.ContributionsTbl.ContributionAmount, 0)) AS [Sum of Contributions], COUNT_BIG(*) AS CountBig
FROM            dbo.CharityTbl INNER JOIN
                         dbo.ContributionsTbl ON dbo.CharityTbl.CharityID = dbo.ContributionsTbl.CharityID
GROUP BY dbo.CharityTbl.CharityID, dbo.CharityTbl.CharityName, dbo.CharityTbl.CharityRegisteresedOffice
GO