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

Skip to content

Raizcorp Technical Documentation

Query: Qry Sum Total Sponsor Elements Spend by Principal Project

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

Tables Referenced

Principal Project Pillar Sponsor Elements
Entrepreneur
Principal Project Pillars
Entrepreneur Company Extra Sponsor Elements

Columns Selected

[Principal Project Pillars].[Principal Project ID]
Sum([Entrepreneur Company Extra Sponsor Elements].[Extra Sponsorship Amount])

SQL

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