Skip to content

Query: Qry Sales Briefs Assigned to Principal List

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

Tables Referenced

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

Columns Selected

  • [Principals Sales].[Principal ID]
  • [Sales Brief].[Date Created]
  • [Sales Brief].[Solutions Architect]
  • [Sales Brief Status].[Sales Brief Status]

SQL

SELECT [Principals Sales].[Principal ID], [Sales Brief].[Date Created], [Sales Brief].[Solutions Architect], [Sales Brief Status].[Sales Brief Status] FROM [Principals Sales], [Sales Brief], [Sales Brief Status]