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

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

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]