Query: Qry Job Code Regret Resons NOT in List

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

Tables Referenced

• Regret Reasons
• SubQry
• SubQry Job Code Regret Reasons NOT in List

Columns Selected

• [Regret Reasons].[Regret Reason ID]
• [Regret Reasons].[Regret Reason]
• [Regret Reasons].[Sort Order]
• Active

Where Clause

((([Regret Reasons].Active)=True) AND (([SubQry Job Code Regret Reasons NOT in L

SQL

SELECT [Regret Reasons].[Regret Reason ID], [Regret Reasons].[Regret Reason], [Regret Reasons].[Sort Order], [Regret Reasons].Active FROM [SubQry Job Code Regret Reasons NOT in List], [Regret Reasons] WHERE ((([Regret Reasons].Active)=True) AND (([SubQry Job Code Regret Reasons NOT in L