Skip to content

Query: Qry Company Principal Project List

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

Tables Referenced

  • VAPackAuditStatus
  • vwPurpleAuditCompanyPrincipalProjectList

Columns Selected

  • vwPurpleAuditCompanyPrincipalProjectList.[Entrepreneur Company Principal Project
  • vwPurpleAuditCompanyPrincipalProjectList.[Company Name]
  • vwPurpleAuditCompanyPrincipalProjectList.[Principal Project]
  • vwPurpleAuditCompanyPrincipalProjectList.[Date Contract Signed]
  • vwPurpleAuditCompanyPrincipalProjectList.[VA Pack Audit Status ID]
  • VAPackAuditStatus.[VA Pack Audit Status]
  • vwPurpleAuditCompanyPrincipalProjectList.[Date Status Changed]
  • vwPurpleAuditCompanyPrincipalProjectList.[Status Changed By]
  • vwPurpleAuditCompanyPrincipalProjectList.[Audit Score]

SQL

SELECT vwPurpleAuditCompanyPrincipalProjectList.[Entrepreneur Company Principal Project, vwPurpleAuditCompanyPrincipalProjectList.[Company Name], vwPurpleAuditCompanyPrincipalProjectList.[Principal Project], vwPurpleAuditCompanyPrincipalProjectList.[Date Contract Signed], vwPurpleAuditCompanyPrincipalProjectList.[VA Pack Audit Status ID], VAPackAuditStatus.[VA Pack Audit Status], vwPurpleAuditCompanyPrincipalProjectList.[Date Status Changed], vwPurpleAuditCompanyPrincipalProjectList.[Status Changed By], vwPurpleAuditCompanyPrincipalProjectList.[Audit Score] FROM [VAPackAuditStatus], [vwPurpleAuditCompanyPrincipalProjectList]