Skip to content

Query: Qry Export Organisational Codes Engage

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

Tables Referenced

  • Organisational Codes
  • Organisational

Columns Selected

  • [Organisational Codes].[Organisational ID]
  • [Organisational Codes].[Organisational Code]
  • [Organisational Codes].[Organisational Unit]
  • [Organisational Codes].[Organisational Unit Description]
  • [Organisational Codes].[Organisational Unit Parent]

Where Clause

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

SQL

SELECT [Organisational Codes].[Organisational ID], [Organisational Codes].[Organisational Code], [Organisational Codes].[Organisational Unit], [Organisational Codes].[Organisational Unit Description], [Organisational Codes].[Organisational Unit Parent] FROM [Organisational Codes] WHERE ((([Organisational Codes].[Organisational Code]) Is Not Null))