Skip to content

Query: Qry Export Lead Summary Report

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

Tables Referenced

  • Positions
  • Applications
  • Job Codes
  • Organisational Codes
  • Application Status

Columns Selected

  • Job
  • Positions.[Position ID]
  • [Organisational Codes].[Organisational Unit]
  • Positions.[Position Status ID]
  • [Application Status].[Application Status]
  • Count(Applications.[Application ID])
  • [Application Status].[Sort Order]

Order By

[Job Codes].Job, Positions.[Position ID], [Organisational Codes].[Organisational Unit], [Application Status].[Sort Order]

SQL

SELECT [Job Codes].Job, Positions.[Position ID], [Organisational Codes].[Organisational Unit], Positions.[Position Status ID], [Application Status].[Application Status], Count(Applications.[Application ID]), [Application Status].[Sort Order] FROM [Applications], [Positions], [Application Status], [Job Codes], [Organisational Codes]