Skip to content

Query: Qry Proposals Assigned to Principal List

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

Tables Referenced

  • Principals
  • Proposal
  • Proposal Status
  • Principals Sales

Columns Selected

  • [Principals Sales].[Principal ID]
  • Proposal.[Date Created]
  • Proposal.[Opportunity Owner]
  • [Proposal Status].[Proposal Status]

SQL

SELECT [Principals Sales].[Principal ID], Proposal.[Date Created], Proposal.[Opportunity Owner], [Proposal Status].[Proposal Status] FROM [Principals Sales], [Proposal], [Proposal Status]