Skip to content

Query: SubQry Export Commitment Fee Information for Notification

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

Tables Referenced

  • Entrepreneur Company Programme Years
  • Delivery Locations
  • Entrepreneur Company
  • Entrepreneur
  • Products

Columns Selected

  • [Entrepreneur Company Programme Years].[Committment Fee Invoiced]
  • [Entrepreneur Company].[Entrepreneur Company ID]
  • [Entrepreneur Company Programme Years].[Entrepreneur Company Programme Years ID]
  • [Delivery Locations].[Delivery Location]
  • [Entrepreneur Company].[Company Name]
  • [Entrepreneur Company Programme Years].[Contract Start Date]

SQL

SELECT [Entrepreneur Company Programme Years].[Committment Fee Invoiced], [Entrepreneur Company].[Entrepreneur Company ID], [Entrepreneur Company Programme Years].[Entrepreneur Company Programme Years ID], [Delivery Locations].[Delivery Location], [Entrepreneur Company].[Company Name], [Entrepreneur Company Programme Years].[Contract Start Date] FROM [Entrepreneur Company], [Products], [Entrepreneur Company Programme Years], [Delivery Locations]