Skip to content

Query: SubQry Sum Current On Prog by Prosperator Principal Proj Product

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

Tables Referenced

  • vwGarnetPreSumCurrentOnProgbyProsperatorPrinProjProductCrit
  • vwGarnetSumTotalBilledbyPrincipalProjectDeliveryLocation

Columns Selected

  • vwGarnetPreSumCurrentOnProgbyProsperatorPrinProjProductCrit.[Company Delivery Lo
  • vwGarnetPreSumCurrentOnProgbyProsperatorPrinProjProductCrit.[Delivery Location]
  • vwGarnetPreSumCurrentOnProgbyProsperatorPrinProjProductCrit.[Principal Project I
  • Principal
  • vwGarnetPreSumCurrentOnProgbyProsperatorPrinProjProductCrit.[Project Name]
  • vwGarnetPreSumCurrentOnProgbyProsperatorPrinProjProductCrit.[Product ID]
  • vwGarnetPreSumCurrentOnProgbyProsperatorPrinProjProductCrit.[Contract Start Date

SQL

SELECT vwGarnetPreSumCurrentOnProgbyProsperatorPrinProjProductCrit.[Company Delivery Lo, vwGarnetPreSumCurrentOnProgbyProsperatorPrinProjProductCrit.[Delivery Location], vwGarnetPreSumCurrentOnProgbyProsperatorPrinProjProductCrit.[Principal Project I, vwGarnetPreSumCurrentOnProgbyProsperatorPrinProjProductCrit.Principal, vwGarnetPreSumCurrentOnProgbyProsperatorPrinProjProductCrit.[Project Name], vwGarnetPreSumCurrentOnProgbyProsperatorPrinProjProductCrit.[Product ID], vwGarnetPreSumCurrentOnProgbyProsperatorPrinProjProductCrit.[Contract Start Date FROM [vwGarnetPreSumCurrentOnProgbyProsperatorPrinProjProductCrit], [vwGarnetSumTotalBilledbyPrincipalProjectDeliveryLocation]