Skip to content

Query: Qry Get Entrepreneur Steps by Recommended Principal Project

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

Tables Referenced

  • vwPurpleGetEntrepreneurSteps
  • SubQry
  • SubQry Get Entrepreneur Steps Recommended Principal Project Crit

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 Recommended Principal Project Crit], [vwPurpleGetEntrepreneurSteps]