Skip to content

Query: Qry Marketing Budget Non Principal Project List

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

Tables Referenced

  • MarketingBudgetStatus
  • Marketing Budget Non Principal Project
  • Marketing

Columns Selected

  • [Marketing Budget Non Principal Project].[Marketing Budget ID]
  • [Marketing Budget Non Principal Project].[Date Budget Created]
  • [Marketing Budget Non Principal Project].[Marketing Budget Status ID]
  • Status
  • [Marketing Budget Non Principal Project].[Budget Year]
  • [Marketing Budget Non Principal Project].[Budget Description]
  • [Marketing Budget Non Principal Project].[Budget Amount]

SQL

SELECT [Marketing Budget Non Principal Project].[Marketing Budget ID], [Marketing Budget Non Principal Project].[Date Budget Created], [Marketing Budget Non Principal Project].[Marketing Budget Status ID], MarketingBudgetStatus.Status, [Marketing Budget Non Principal Project].[Budget Year], [Marketing Budget Non Principal Project].[Budget Description], [Marketing Budget Non Principal Project].[Budget Amount] FROM [Marketing Budget Non Principal Project], [MarketingBudgetStatus]