Skip to content

Query: SubQry Rpt Count Total Leads Generated

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

Tables Referenced

  • SubQry Rpt Marketing Leads Criteria
  • SubQry

Columns Selected

  • [SubQry Rpt Marketing Leads Criteria].[Lead Type ID]
  • [SubQry Rpt Marketing Leads Criteria].[Lead Type]
  • Count([SubQry Rpt Marketing Leads Criteria].[Entrepreneur ID])

SQL

SELECT [SubQry Rpt Marketing Leads Criteria].[Lead Type ID], [SubQry Rpt Marketing Leads Criteria].[Lead Type], Count([SubQry Rpt Marketing Leads Criteria].[Entrepreneur ID]) FROM [SubQry Rpt Marketing Leads Criteria]