Skip to content

Query: SubQry Rpt Opal Prin Proj Summary Count Active Comp

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

Tables Referenced

  • SubQry Rpt Opal Principal Project Summary Criteria
  • SubQry

Columns Selected

  • [SubQry Rpt Opal Principal Project Summary Criteria].[Principal Project ID]
  • [SubQry Rpt Opal Principal Project Summary Criteria].[Principal Project]
  • Count([SubQry Rpt Opal Principal Project Summary Criteria].[Entrepreneur Company

Order By

[SubQry Rpt Opal Principal Project Summary Criteria].[Principal Project]

SQL

SELECT [SubQry Rpt Opal Principal Project Summary Criteria].[Principal Project ID], [SubQry Rpt Opal Principal Project Summary Criteria].[Principal Project], Count([SubQry Rpt Opal Principal Project Summary Criteria].[Entrepreneur Company FROM [SubQry Rpt Opal Principal Project Summary Criteria]