Skip to content

Query: Qry Duplicate Entrepreneurs

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

Tables Referenced

  • SubQry Duplicate Entrepreneurs Alt
  • Lead Types
  • ProcessStatus
  • Lead

Columns Selected

  • [SubQry Duplicate Entrepreneurs Alt].[Entrepreneur ID]
  • [First Name] & \
  • [SubQry Duplicate Entrepreneurs Alt].[EOI Business Name]
  • [SubQry Duplicate Entrepreneurs Alt].[Email Address]
  • ProcessStatus.[Step Number]
  • Status
  • [SubQry Duplicate Entrepreneurs Alt].[Date Status Changed]
  • [Lead Types].[Lead Type]

SQL

SELECT [SubQry Duplicate Entrepreneurs Alt].[Entrepreneur ID], [First Name] & \, [SubQry Duplicate Entrepreneurs Alt].[EOI Business Name], [SubQry Duplicate Entrepreneurs Alt].[Email Address], ProcessStatus.[Step Number], ProcessStatus.Status, [SubQry Duplicate Entrepreneurs Alt].[Date Status Changed], [Lead Types].[Lead Type] FROM [Lead Types], [ProcessStatus], [SubQry Duplicate Entrepreneurs Alt]