Skip to content

Query: Qry Get Multiple Zones by Product

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

Tables Referenced

  • Distribution Models
  • Product
  • Product Distribution Models

Columns Selected

  • [Product Distribution Models].[Product ID]
  • [Distribution Models].[Uses Multiple Zones]

Where Clause

((([Distribution Models].[Uses Multiple Zones])=True))

SQL

SELECT [Product Distribution Models].[Product ID], [Distribution Models].[Uses Multiple Zones] FROM [Product Distribution Models], [Distribution Models] WHERE ((([Distribution Models].[Uses Multiple Zones])=True))