Skip to content

Query: Qry Export Job List Engage

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

Tables Referenced

  • Job Codes
  • Job

Columns Selected

  • [Job Codes].[Job ID]
  • [Job Codes].[Job Code]
  • Job
  • DESCRIPTION

Where Clause

((([Job Codes].[Job Code]) Is Not Null))

SQL

SELECT [Job Codes].[Job ID], [Job Codes].[Job Code], [Job Codes].Job, [Job Codes].DESCRIPTION FROM [Job Codes] WHERE ((([Job Codes].[Job Code]) Is Not Null))