Skip to content

Query: Qry SubRpt Sub Products

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

Tables Referenced

  • Sub Products Sales
  • Sales
  • Sales Brief Sub Products

Columns Selected

  • [Sales Brief Sub Products].[Sales Brief ID]
  • [Sales Brief Sub Products].[BBBEE Pillar]
  • [Sub Products Sales].[Sub Product]
  • [Sales Brief Sub Products].[Sponsorship Amount]
  • [Sales Brief Sub Products].[Number of Entrepreneurs]
  • Frequency

SQL

SELECT [Sales Brief Sub Products].[Sales Brief ID], [Sales Brief Sub Products].[BBBEE Pillar], [Sub Products Sales].[Sub Product], [Sales Brief Sub Products].[Sponsorship Amount], [Sales Brief Sub Products].[Number of Entrepreneurs], [Sales Brief Sub Products].Frequency FROM [Sales Brief Sub Products], [Sub Products Sales]