Skip to content

Query: Qry Sales Brief List

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

Tables Referenced

  • Sales
  • Sales Brief Status
  • Sales Brief
  • Principals Sales

Columns Selected

  • [Sales Brief].[Sales Brief ID]
  • [Sales Brief].[Date Created]
  • [Sales Brief].[Version Number]
  • [Principal] & IIf(Not IsNull([Project]),\
  • [Sales Brief].[Solutions Architect]
  • [Sales Brief].[Key Account Manager]
  • [Sales Brief].[Sales Brief Status ID]
  • [Sales Brief Status].[Sales Brief Status]
  • [Sales Brief].[Sales Brief Number]

SQL

SELECT [Sales Brief].[Sales Brief ID], [Sales Brief].[Date Created], [Sales Brief].[Version Number], [Principal] & IIf(Not IsNull([Project]),\, [Sales Brief].[Solutions Architect], [Sales Brief].[Key Account Manager], [Sales Brief].[Sales Brief Status ID], [Sales Brief Status].[Sales Brief Status], [Sales Brief].[Sales Brief Number] FROM [Sales Brief], [Sales Brief Status], [Principals Sales]