Skip to content

Query: Qry SubRpt Sales Brief Marketing

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

Tables Referenced

  • Sales Brief Selection Marketing
  • Qry Get Principal Marketing Contact by Sales Brief
  • Sales

Columns Selected

  • [Sales Brief Selection Marketing].[Sales Brief Selection Marketing ID]
  • [Sales Brief Selection Marketing].[Sales Brief ID]
  • [Sales Brief Selection Marketing].[BBBEE Pillar]
  • IIf([Marketing Campaign Required]=1,\
  • IIf([Principal Campaign Branded]=1,\
  • [Qry Get Principal Marketing Contact by Sales Brief].[Marketing Contact Name]
  • [Qry Get Principal Marketing Contact by Sales Brief].[Marketing Contact Email]
  • [Qry Get Principal Marketing Contact by Sales Brief].[Marketing Contact Phone]
  • IIf([Launch Required]=1,\
  • IIf([Who Arranges Launch]=1,\
  • [Sales Brief Selection Marketing].[Raizcorp Launch Budget]
  • [Sales Brief Selection Marketing].[Principal Launch Budget]
  • [Sales Brief Selection Marketing].[PR Type]
  • [Sales Brief Selection Marketing].[Info Session Type]

SQL

SELECT [Sales Brief Selection Marketing].[Sales Brief Selection Marketing ID], [Sales Brief Selection Marketing].[Sales Brief ID], [Sales Brief Selection Marketing].[BBBEE Pillar], IIf([Marketing Campaign Required]=1,\, IIf([Principal Campaign Branded]=1,\, [Qry Get Principal Marketing Contact by Sales Brief].[Marketing Contact Name], [Qry Get Principal Marketing Contact by Sales Brief].[Marketing Contact Email], [Qry Get Principal Marketing Contact by Sales Brief].[Marketing Contact Phone], IIf([Launch Required]=1,\, IIf([Who Arranges Launch]=1,\, [Sales Brief Selection Marketing].[Raizcorp Launch Budget], [Sales Brief Selection Marketing].[Principal Launch Budget], [Sales Brief Selection Marketing].[PR Type], [Sales Brief Selection Marketing].[Info Session Type] FROM [Sales Brief Selection Marketing], [Qry Get Principal Marketing Contact by Sales Brief]