Skip to content

Query: Qry Get Last Pre-Ignition Job Entry by Company

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

Tables Referenced

  • Qry
  • Entrepreneur Company Pre Ignition Financials
  • Qry Get Last Pre-Ignition Month Name Year by Company

Columns Selected

  • [Entrepreneur Company Pre Ignition Financials].[Entrepreneur Company ID]
  • Directors
  • [Entrepreneur Company Pre Ignition Financials].[Permanent Staff]
  • [Entrepreneur Company Pre Ignition Financials].[Contract Staff]

SQL

SELECT [Entrepreneur Company Pre Ignition Financials].[Entrepreneur Company ID], [Entrepreneur Company Pre Ignition Financials].Directors, [Entrepreneur Company Pre Ignition Financials].[Permanent Staff], [Entrepreneur Company Pre Ignition Financials].[Contract Staff] FROM [Qry Get Last Pre-Ignition Month Name Year by Company], [Entrepreneur Company Pre Ignition Financials]