Skip to content

Query: Qry Job Code Application Step List

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

Tables Referenced

  • Application Status
  • Job Code Application Steps
  • Job

Columns Selected

  • [Job Code Application Steps].[Job Code Application Step ID]
  • [Job Code Application Steps].[Job ID]
  • [Job Code Application Steps].[Application Status ID]
  • [Application Status].[Application Status]
  • [Application Status].[Assessment Step]
  • [Application Status].[Sort Order]
  • Active
  • [Application Status].[Stage Number]

SQL

SELECT [Job Code Application Steps].[Job Code Application Step ID], [Job Code Application Steps].[Job ID], [Job Code Application Steps].[Application Status ID], [Application Status].[Application Status], [Application Status].[Assessment Step], [Application Status].[Sort Order], [Application Status].Active, [Application Status].[Stage Number] FROM [Job Code Application Steps], [Application Status]