Skip to content

Query: Qry Report Lead Type to Principal Allocation

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

Tables Referenced

  • SubQry Rpt Lead Type to Principal Allocation Criteria
  • SubQry

Columns Selected

  • [SubQry Rpt Lead Type to Principal Allocation Criteria].[Lead Type Principal Pro
  • [SubQry Rpt Lead Type to Principal Allocation Criteria].[Lead Type]
  • [SubQry Rpt Lead Type to Principal Allocation Criteria].[Allocated Same as Lead
  • Count([SubQry Rpt Lead Type to Principal Allocation Criteria].[Entrepreneur ID])

SQL

SELECT [SubQry Rpt Lead Type to Principal Allocation Criteria].[Lead Type Principal Pro, [SubQry Rpt Lead Type to Principal Allocation Criteria].[Lead Type], [SubQry Rpt Lead Type to Principal Allocation Criteria].[Allocated Same as Lead , Count([SubQry Rpt Lead Type to Principal Allocation Criteria].[Entrepreneur ID]) FROM [SubQry Rpt Lead Type to Principal Allocation Criteria]