Skip to content

Query: Qry Count Current Entrepreneurs Allocated for Purple

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

Tables Referenced

  • Entrepreneur Company
  • Entrepreneurs

Columns Selected

  • Entrepreneurs.[Recommended Principal Project ID]
  • [Entrepreneur Company].[Company Status ID]
  • Entrepreneurs.[Process Status ID]
  • Count(Entrepreneurs.[Entrepreneur ID])

SQL

SELECT Entrepreneurs.[Recommended Principal Project ID], [Entrepreneur Company].[Company Status ID], Entrepreneurs.[Process Status ID], Count(Entrepreneurs.[Entrepreneur ID]) FROM [Entrepreneurs], [Entrepreneur Company]