Skip to content

Query: Qry Proposal List

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

Tables Referenced

  • Principals
  • Proposal
  • Proposal Status
  • Principals Sales

Columns Selected

  • Proposal.[Proposal ID]
  • Proposal.[Date Created]
  • Proposal.[Version Number]
  • Principal
  • Proposal.[Opportunity Owner]
  • Proposal.[Proposal Status ID]
  • [Proposal Status].[Proposal Status]

SQL

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