Skip to content

Query: Qry SubRpt Sales Brief Status and Revision History

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

Tables Referenced

  • Sales
  • Sales Brief Status
  • Sales Brief
  • Sales Brief Status History

Columns Selected

  • [Sales Brief Status History].[Sales Brief Status History ID]
  • [Sales Brief].[Sales Brief Number]
  • [Sales Brief].[Version Number]
  • [Sales Brief Status].[Sales Brief Status]
  • [Sales Brief Status History].[Date Status Changed]
  • [Sales Brief Status History].[Status Modified By]
  • [Sales Brief Status].[Sort Order]

SQL

SELECT [Sales Brief Status History].[Sales Brief Status History ID], [Sales Brief].[Sales Brief Number], [Sales Brief].[Version Number], [Sales Brief Status].[Sales Brief Status], [Sales Brief Status History].[Date Status Changed], [Sales Brief Status History].[Status Modified By], [Sales Brief Status].[Sort Order] FROM [Sales Brief], [Sales Brief Status History], [Sales Brief Status]