Skip to content

Query: Qry Report Principal Project Product Totals by Delivery Location

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

Tables Referenced

  • SubQry Sum Current On Prog by Prosperator Principal Proj Product
  • SubQry

Columns Selected

  • [SubQry Sum Current On Prog by Prosperator Principal Proj Product].[Delivery Loc
  • Principal
  • [SubQry Sum Current On Prog by Prosperator Principal Proj Product].[Project Name
  • [SubQry Sum Current On Prog by Prosperator Principal Proj Product].[Contract Sta

Order By

[SubQry Sum Current On Prog by Prosperator Principal Proj Product].[Delivery Loc, [SubQry Sum Current On Prog by Prosperator Principal Proj Product].Principal, [SubQry Sum Current On Prog by Prosperator Principal Proj Product].[Company Prod

SQL

SELECT [SubQry Sum Current On Prog by Prosperator Principal Proj Product].[Delivery Loc, [SubQry Sum Current On Prog by Prosperator Principal Proj Product].Principal, [SubQry Sum Current On Prog by Prosperator Principal Proj Product].[Project Name, [SubQry Sum Current On Prog by Prosperator Principal Proj Product].[Contract Sta FROM [SubQry Sum Current On Prog by Prosperator Principal Proj Product]