Skip to content

Query: Qry Job Code Pre Appointment Documents NOT in the List

Type: Delete
Has Parameters: No
Has Joins: No
Has Subquery: No

Tables Referenced

  • SubQry Job Code Pre Appointment Documents NOT in the List
  • SubQry
  • Pre Appointment Documents

Columns Selected

  • [Pre Appointment Documents].[Pre Appointment Document ID]
  • [Pre Appointment Documents].[Pre Appointment Document Category ID]
  • [Pre Appointment Documents].[Pre Appointment Document]

Where Clause

((([SubQry Job Code Pre Appointment Documents NOT in the List].[Pre Appointment

SQL

SELECT [Pre Appointment Documents].[Pre Appointment Document ID], [Pre Appointment Documents].[Pre Appointment Document Category ID], [Pre Appointment Documents].[Pre Appointment Document] FROM [SubQry Job Code Pre Appointment Documents NOT in the List], [Pre Appointment Documents] WHERE ((([SubQry Job Code Pre Appointment Documents NOT in the List].[Pre Appointment