Skip to content

Query: SubQry Get Entrepreneur Steps Recommended Principal Project Crit

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

Tables Referenced

  • vwPurpleGetEntrepreneurStepsCriteria

Columns Selected

  • vwPurpleGetEntrepreneurStepsCriteria.[Recommended Principal Project ID]
  • vwPurpleGetEntrepreneurStepsCriteria.[Step Number]
  • vwPurpleGetEntrepreneurStepsCriteria.[Pipeline ID]
  • vwPurpleGetEntrepreneurStepsCriteria.[Entrepreneur ID]

Where Clause

(((vwPurpleGetEntrepreneurStepsCriteria.[Recommended Principal Project ID])=[For

SQL

SELECT vwPurpleGetEntrepreneurStepsCriteria.[Recommended Principal Project ID], vwPurpleGetEntrepreneurStepsCriteria.[Step Number], vwPurpleGetEntrepreneurStepsCriteria.[Pipeline ID], vwPurpleGetEntrepreneurStepsCriteria.[Entrepreneur ID] FROM [vwPurpleGetEntrepreneurStepsCriteria] WHERE (((vwPurpleGetEntrepreneurStepsCriteria.[Recommended Principal Project ID])=[For