Skip to content

Query: Qry Pre Ignition List

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].[Pre Ignition ID]
  • [Entrepreneur Company Pre Ignition Financials].[Date Created]
  • [Entrepreneur Company Pre Ignition Financials].[Entrepreneur Company ID]
  • [Submission Month] & \
  • Bookkeeper
  • [Entrepreneur Company Pre Ignition Financials].[Submission Month]
  • [Entrepreneur Company Pre Ignition Financials].[Submission Year]
  • MonthLkUp.[Month Number]

SQL

SELECT [Entrepreneur Company Pre Ignition Financials].[Pre Ignition ID], [Entrepreneur Company Pre Ignition Financials].[Date Created], [Entrepreneur Company Pre Ignition Financials].[Entrepreneur Company ID], [Submission Month] & \, [Entrepreneur Company Pre Ignition Financials].Bookkeeper, [Entrepreneur Company Pre Ignition Financials].[Submission Month], [Entrepreneur Company Pre Ignition Financials].[Submission Year], MonthLkUp.[Month Number] FROM [Entrepreneur Company Pre Ignition Financials], [MonthLkUp]