Skip to content

Query: Qry Get Last Complete Submission by Company

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

Tables Referenced

  • Submissions
  • Qry Get Last Complete Submission ID by Company
  • SubQry Get Last Complete Submission by Company
  • SubQry

Columns Selected

  • Submissions.[Entrepreneur Company ID]
  • [Submission Month] & \
  • [SubQry Get Last Complete Submission by Company].[Submission ID]

SQL

SELECT Submissions.[Entrepreneur Company ID], [Submission Month] & \, [SubQry Get Last Complete Submission by Company].[Submission ID] FROM [SubQry Get Last Complete Submission by Company], [Qry Get Last Complete Submission ID by Company], [Submissions]