Skip to content

Query: Qry Report Principal Spend by Company

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

Tables Referenced

  • Entrepreneur Company
  • SubQry Rpt Sum Principal Spend by Company
  • Principals

Columns Selected

  • [Entrepreneur Company].[Company Name]
  • Principal
  • [SubQry Rpt Sum Principal Spend by Company].[Total Principal Spend]

Order By

[Entrepreneur Company].[Company Name], Principals.Principal

SQL

SELECT [Entrepreneur Company].[Company Name], Principals.Principal, [SubQry Rpt Sum Principal Spend by Company].[Total Principal Spend] FROM [Principals], [SubQry Rpt Sum Principal Spend by Company], [Entrepreneur Company]