Skip to content

Query: Qry Report Principal Spend by Delivery Location

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

Tables Referenced

  • SubQry Rpt Sum Principal Spend by Delivery Location
  • Delivery Locations
  • SubQry
  • Principals

Columns Selected

  • [Delivery Locations].[Delivery Location]
  • Principal
  • [SubQry Rpt Sum Principal Spend by Delivery Location].[Total Principal Spend]

Order By

[Delivery Locations].[Delivery Location], Principals.Principal

SQL

SELECT [Delivery Locations].[Delivery Location], Principals.Principal, [SubQry Rpt Sum Principal Spend by Delivery Location].[Total Principal Spend] FROM [SubQry Rpt Sum Principal Spend by Delivery Location], [Delivery Locations], [Principals]