Skip to content

Query: Qry Get Last Pre-Ignition Month Year by Company

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

Tables Referenced

  • Entrepreneur Company Pre Ignition Financials
  • Entrepreneur
  • MonthLkUp

Columns Selected

  • [Entrepreneur Company Pre Ignition Financials].[Entrepreneur Company ID]
  • Max(MonthLkUp.[Month Number])
  • Max([Entrepreneur Company Pre Ignition Financials].[Submission Year])

Order By

[Entrepreneur Company Pre Ignition Financials].[Entrepreneur Company ID]

SQL

SELECT [Entrepreneur Company Pre Ignition Financials].[Entrepreneur Company ID], Max(MonthLkUp.[Month Number]), Max([Entrepreneur Company Pre Ignition Financials].[Submission Year]) FROM [Entrepreneur Company Pre Ignition Financials], [MonthLkUp]