Skip to content

Query: Qry Report P3 Graduates Not Active Exited 5 Months Ago

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

Tables Referenced

  • Entrepreneur
  • CompanyStatus
  • Entrepreneur Company
  • Qry Get Last Programme Year ID by Company
  • CompanyProgrammeYearStatus
  • Entrepreneur Company Programme Years
  • Entrepreneurs

Columns Selected

  • [Entrepreneur Company Programme Years].[Product ID]
  • [Entrepreneur Company].[Company Status ID]
  • [Entrepreneur Company].[Entrepreneur Company ID]
  • [Entrepreneur Company Programme Years].[Company Programme Year Status ID]
  • Status
  • DateAdd(\
  • [Entrepreneur Company Programme Years].[Date Status Changed]
  • [Entrepreneur Company].[Company Name]
  • [Entrepreneur Company].[Brief Description of Business]
  • [First Name] & \
  • Entrepreneurs.[Telephone Number]
  • Entrepreneurs.[Email Address]

Where Clause

((([Entrepreneur Company Programme Years].[Product ID])=7) AND (([Entrepreneur C

SQL

SELECT [Entrepreneur Company Programme Years].[Product ID], [Entrepreneur Company].[Company Status ID], [Entrepreneur Company].[Entrepreneur Company ID], [Entrepreneur Company Programme Years].[Company Programme Year Status ID], CompanyStatus.Status, DateAdd(\, [Entrepreneur Company Programme Years].[Date Status Changed], [Entrepreneur Company].[Company Name], [Entrepreneur Company].[Brief Description of Business], [First Name] & \, Entrepreneurs.[Telephone Number], Entrepreneurs.[Email Address] FROM [Entrepreneur Company Programme Years], [Entrepreneur Company], [Entrepreneurs], [CompanyStatus], [CompanyProgrammeYearStatus], [Qry Get Last Programme Year ID by Company] WHERE ((([Entrepreneur Company Programme Years].[Product ID])=7) AND (([Entrepreneur C