Skip to content

Query: Qry Marketing Campaign List Other

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

Tables Referenced

  • MarketingCampaignStatus
  • Qry Sum Total Spend by Principal Project
  • Marketing Campaigns
  • Principal Projects
  • Qry Budget Spend Totals by Marketing Campaign
  • Principals

Columns Selected

  • [Marketing Campaigns].[Marketing Campaign ID]
  • [Principal Projects].[Principal Project ID]
  • [Marketing Campaigns].[Marketing Campaign Status ID]
  • [Principal] & \
  • [Qry Sum Total Spend by Principal Project].[Total Companies Required]
  • [Principal Projects].[Standard Marketing Budget]
  • [Qry Budget Spend Totals by Marketing Campaign].[Marketing Spend]
  • Remaining
  • [Principal Projects].[Additional Marketing Costs]
  • [Marketing Campaigns].[Marketing Campaign]
  • [Marketing Campaigns].[Job Number]
  • Status

SQL

SELECT [Marketing Campaigns].[Marketing Campaign ID], [Principal Projects].[Principal Project ID], [Marketing Campaigns].[Marketing Campaign Status ID], [Principal] & \, [Qry Sum Total Spend by Principal Project].[Total Companies Required], [Principal Projects].[Standard Marketing Budget], [Qry Budget Spend Totals by Marketing Campaign].[Marketing Spend], [Qry Budget Spend Totals by Marketing Campaign].Remaining, [Principal Projects].[Additional Marketing Costs], [Marketing Campaigns].[Marketing Campaign], [Marketing Campaigns].[Job Number], MarketingCampaignStatus.Status FROM [Principals], [Principal Projects], [Qry Sum Total Spend by Principal Project], [Marketing Campaigns], [MarketingCampaignStatus], [Qry Budget Spend Totals by Marketing Campaign]