Skip to content

Query: Find duplicates for Qry Report Termination Analysis Data

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

Tables Referenced

  • Qry
  • Qry Report Termination Analysis Data

Columns Selected

  • [Qry Report Termination Analysis Data].[Entrepreneur ID]
  • Status
  • Entrepreneur
  • [Qry Report Termination Analysis Data].[Company Name]

Where Clause

((([Qry Report Termination Analysis Data].[Entrepreneur ID]) In (SELECT [Entrepr

Order By

[Qry Report Termination Analysis Data].[Entrepreneur ID]

SQL

SELECT [Qry Report Termination Analysis Data].[Entrepreneur ID], [Qry Report Termination Analysis Data].[Status], [Qry Report Termination Analysis Data].[Entrepreneur], [Qry Report Termination Analysis Data].[Company Name] FROM [Qry Report Termination Analysis Data] WHERE ((([Qry Report Termination Analysis Data].[Entrepreneur ID]) In (SELECT [Entrepr