Skip to content

Raizcorp Technical Documentation

Query: Qry Get Entrepreneur Steps by Owned By

Query: Qry Get Entrepreneur Steps by Owned By

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

Tables Referenced

vwPurpleGetEntrepreneurSteps
SubQry
SubQry Get Entrepreneur Steps Owned by Criteria

Columns Selected

vwPurpleGetEntrepreneurSteps.[Entrepreneur ID]
vwPurpleGetEntrepreneurSteps.[Step Number]
Max(vwPurpleGetEntrepreneurSteps.[Date Status Changed])

Order By

vwPurpleGetEntrepreneurSteps.[Entrepreneur ID], vwPurpleGetEntrepreneurSteps.[Step Number]

SQL

SELECT vwPurpleGetEntrepreneurSteps.[Entrepreneur ID], vwPurpleGetEntrepreneurSteps.[Step Number], Max(vwPurpleGetEntrepreneurSteps.[Date Status Changed]) FROM [SubQry Get Entrepreneur Steps Owned by Criteria], [vwPurpleGetEntrepreneurSteps]