Skip to content

Raizcorp Technical Documentation

Query: Qry Count Entrepreneurs Pipeline Phase 3 by Rec PP

Query: Qry Count Entrepreneurs Pipeline Phase 3 by Rec PP

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

Tables Referenced

ProcessStatus
Entrepreneurs
ProcessStep

Columns Selected

Entrepreneurs.[Recommended Principal Project ID]
Phase
Count(Entrepreneurs.[Entrepreneur ID])

SQL

SELECT Entrepreneurs.[Recommended Principal Project ID], ProcessStep.Phase, Count(Entrepreneurs.[Entrepreneur ID]) FROM [Entrepreneurs], [ProcessStatus], [ProcessStep]