Skip to content

Raizcorp Technical Documentation

Query: SubQry Rpt Count Entrepreneurs In the Pipeline

Query: SubQry Rpt Count Entrepreneurs In the Pipeline

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

Tables Referenced

ProcessStatus
Entrepreneurs

Columns Selected

OwnedBy
Count(Entrepreneurs.[Entrepreneur ID])

Where Clause

(((ProcessStatus.[Step Number])>=2 And (ProcessStatus.[Step Number])<=7))

SQL

SELECT Entrepreneurs.OwnedBy, Count(Entrepreneurs.[Entrepreneur ID]) FROM [Entrepreneurs], [ProcessStatus] WHERE (((ProcessStatus.[Step Number])>=2 And (ProcessStatus.[Step Number])<=7))