Skip to content

Query: SubQry Rpt Sum Principal Spend by Delivery Location

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

Tables Referenced

  • Entrepreneur Company
  • Principal Project Pillars
  • Principal Projects
  • Entrepreneur Company Principal Projects
  • Submissions
  • Submissions Principal Spend

Columns Selected

  • Submissions.[Submission Month]
  • Submissions.[Submission Year]
  • [Entrepreneur Company].[Company Delivery Location ID]
  • [Principal Projects].[Principal ID]
  • Sum([Submissions Principal Spend].[Principal Spend])

SQL

SELECT Submissions.[Submission Month], Submissions.[Submission Year], [Entrepreneur Company].[Company Delivery Location ID], [Principal Projects].[Principal ID], Sum([Submissions Principal Spend].[Principal Spend]) FROM [Submissions], [Submissions Principal Spend], [Entrepreneur Company Principal Projects], [Principal Project Pillars], [Principal Projects], [Entrepreneur Company]