Query: Qry Sum Total Sponsor Elements by Principal Project - Raizcorp Technical Documentation

Skip to content

Raizcorp Technical Documentation

Query: Qry Sum Total Sponsor Elements by Principal Project

Type: Select
Has Parameters: No
Has Joins: No
Has Subquery: No

Tables Referenced

Principal Project Pillar Sponsor Elements
Principal
Principal Project Pillars

Columns Selected

[Principal Project Pillars].[Principal Project ID]
Sum([Principal Project Pillar Sponsor Elements].[Sponsorship Amount])

SQL

SELECT [Principal Project Pillars].[Principal Project ID], Sum([Principal Project Pillar Sponsor Elements].[Sponsorship Amount]) FROM [Principal Project Pillar Sponsor Elements], [Principal Project Pillars]