Skip to content

Query: SubQry Duplicate Entrepreneurs

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

Tables Referenced

  • Entrepreneurs

Columns Selected

  • Entrepreneurs.[First Name]
  • Surname
  • Entrepreneurs.[Telephone Number]
  • Entrepreneurs.[EOI Business Name]
  • Entrepreneurs.[Entrepreneur ID]
  • Entrepreneurs.[Process Status ID]
  • Entrepreneurs.[Date Status Changed]
  • Entrepreneurs.[Lead Type ID]

Where Clause

(((Entrepreneurs.[First Name]) In (SELECT [First Name] FROM [Entrepreneurs] As T

Order By

Entrepreneurs.[First Name], Entrepreneurs.Surname, Entrepreneurs.[Telephone Number]

SQL

SELECT Entrepreneurs.[First Name], Entrepreneurs.Surname, Entrepreneurs.[Telephone Number], Entrepreneurs.[EOI Business Name], Entrepreneurs.[Entrepreneur ID], Entrepreneurs.[Process Status ID], Entrepreneurs.[Date Status Changed], Entrepreneurs.[Lead Type ID] FROM [Entrepreneurs] WHERE (((Entrepreneurs.[First Name]) In (SELECT [First Name] FROM [Entrepreneurs] As T