Skip to content

Query: Qry SubRpt Entrepreneur Edit Status History

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

Tables Referenced

  • Entrepreneur Status History
  • Entrepreneur
  • ProcessStatus

Columns Selected

  • [Entrepreneur Status History].[Entrepreneur ID]
  • [Entrepreneur Status History].[Date Status Changed]
  • [Entrepreneur Status History].[Status Modified By]
  • Status
  • ProcessStatus.[Sort Order]
  • [Entrepreneur Status History].[Process Status Notes]

SQL

SELECT [Entrepreneur Status History].[Entrepreneur ID], [Entrepreneur Status History].[Date Status Changed], [Entrepreneur Status History].[Status Modified By], ProcessStatus.Status, ProcessStatus.[Sort Order], [Entrepreneur Status History].[Process Status Notes] FROM [Entrepreneur Status History], [ProcessStatus]