Skip to content

Query: Qry Products NOT in Proposal

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

Tables Referenced

  • Products Proposal
  • SubQry Products NOT in Proposal
  • SubQry

Columns Selected

  • [Products Proposal].[Product ID]
  • Product
  • Active

Where Clause

((([Products Proposal].Active)=True) AND (([SubQry Products NOT in Proposal].[Pr

SQL

SELECT [Products Proposal].[Product ID], [Products Proposal].Product, [Products Proposal].Active FROM [SubQry Products NOT in Proposal], [Products Proposal] WHERE ((([Products Proposal].Active)=True) AND (([SubQry Products NOT in Proposal].[Pr