Skip to content

Query: Qry Get Last Programme Year Info by Company

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

Tables Referenced

  • Entrepreneur Company Programme Years
  • NonGraduateReason
  • Qry
  • CompanyProgrammeYearStatus
  • Qry Get Last Programme Year ID by Company
  • Products

Columns Selected

  • [Qry Get Last Programme Year ID by Company].[Entrepreneur Company ID]
  • [Entrepreneur Company Programme Years].[Programme Year]
  • [Entrepreneur Company Programme Years].[Contract Start Date]

SQL

SELECT [Qry Get Last Programme Year ID by Company].[Entrepreneur Company ID], [Entrepreneur Company Programme Years].[Programme Year], [Entrepreneur Company Programme Years].[Contract Start Date] FROM [Qry Get Last Programme Year ID by Company], [Entrepreneur Company Programme Years], [Products], [CompanyProgrammeYearStatus], [NonGraduateReason]