Skip to content

Query: Qry Get Companies Not Non Graduate

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

Tables Referenced

  • Entrepreneur
  • Entrepreneur Company
  • Entrepreneur Company Programme Years
  • Qry Get Last Ignition Date by Company
  • vwAmberCompanyList

Columns Selected

  • [Entrepreneur Company].[Entrepreneur Company ID]
  • [Entrepreneur Company].[Company Delivery Location ID]
  • [Entrepreneur Company].[Company Status ID]
  • [Entrepreneur Company].[Company Name]
  • [Entrepreneur Company].[Own Bookkeeper]
  • [Entrepreneur Company].[Date RC Bookkeeper Assigned]
  • [Entrepreneur Company].[RC Bookkeeper Assigned]
  • [Entrepreneur Company Programme Years].[Company Programme Year Status ID]
  • [Qry Get Last Ignition Date by Company].[Last Ignition Date]
  • [Entrepreneur Company Programme Years].[Product ID]

Where Clause

((([Entrepreneur Company Programme Years].[Company Programme Year Status ID])<>5

Order By

[Entrepreneur Company].[Company Name]

SQL

SELECT [Entrepreneur Company].[Entrepreneur Company ID], [Entrepreneur Company].[Company Delivery Location ID], [Entrepreneur Company].[Company Status ID], [Entrepreneur Company].[Company Name], [Entrepreneur Company].[Own Bookkeeper], [Entrepreneur Company].[Date RC Bookkeeper Assigned], [Entrepreneur Company].[RC Bookkeeper Assigned], [Entrepreneur Company Programme Years].[Company Programme Year Status ID], [Qry Get Last Ignition Date by Company].[Last Ignition Date], [Entrepreneur Company Programme Years].[Product ID] FROM [Entrepreneur Company], [Entrepreneur Company Programme Years], [Qry Get Last Ignition Date by Company], [vwAmberCompanyList] WHERE ((([Entrepreneur Company Programme Years].[Company Programme Year Status ID])<>5