Skip to content

Query: Qry SubRpt Finance Distribution Model Type Fees

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

Tables Referenced

  • Distribution Model Types
  • Sales
  • Sales Brief Finance Distribution Model Type Fees

Columns Selected

  • [Sales Brief Finance Distribution Model Type Fees].[Sales Brief ID]
  • [Distribution Model Types].[Distribution Model Type]
  • [Distribution Model Types].[Floor Size]
  • Capacity
  • [Sales Brief Finance Distribution Model Type Fees].[Set-up Fee]
  • [Sales Brief Finance Distribution Model Type Fees].[Management Fee]
  • [Sales Brief Finance Distribution Model Type Fees].[Operational Expenses]

SQL

SELECT [Sales Brief Finance Distribution Model Type Fees].[Sales Brief ID], [Distribution Model Types].[Distribution Model Type], [Distribution Model Types].[Floor Size], [Distribution Model Types].Capacity, [Sales Brief Finance Distribution Model Type Fees].[Set-up Fee], [Sales Brief Finance Distribution Model Type Fees].[Management Fee], [Sales Brief Finance Distribution Model Type Fees].[Operational Expenses] FROM [Sales Brief Finance Distribution Model Type Fees], [Distribution Model Types]