Query: SubQry Job Code Regret Reasons NOT in List

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

Tables Referenced

• Regret Reasons
• Job Code Regret Reasons
• Job

Columns Selected

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

Where Clause

((([Job Code Regret Reasons].[Job ID])=[Forms]![Frm Configure Job Regret Reasons

SQL

SELECT [Job Code Regret Reasons].[Job Code Regret Reason ID], [Job Code Regret Reasons].[Job ID], [Job Code Regret Reasons].[Regret Reason ID], [Regret Reasons].[Regret Reason], [Regret Reasons].[Sort Order], [Regret Reasons].Active FROM [Job Code Regret Reasons], [Regret Reasons] WHERE ((([Job Code Regret Reasons].[Job ID])=[Forms]![Frm Configure Job Regret Reasons