Skip to content

Query: Qry SubRpt Submission Status History

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

Tables Referenced

  • Submissions
  • Submissions Status History
  • Submission Status

Columns Selected

  • [Submissions Status History].[Submission ID]
  • [Submissions Status History].[Submission Status ID]
  • [Submission Status].[Submission Status]
  • [Submissions Status History].[Date Status Changed]
  • [Submissions Status History].[Status Modified By]
  • [Submission Status].[Sort Order]

SQL

SELECT [Submissions Status History].[Submission ID], [Submissions Status History].[Submission Status ID], [Submission Status].[Submission Status], [Submissions Status History].[Date Status Changed], [Submissions Status History].[Status Modified By], [Submission Status].[Sort Order] FROM [Submissions Status History], [Submission Status]