Skip to content

Query: SubQry Rpt Opal Prin Proj Summary Count Weighted EPs by Del Loc

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

Tables Referenced

  • SubQry Rpt Opal Principal Project Summary Criteria
  • SubQry
  • Entrepreneurs

Columns Selected

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

SQL

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