Skip to content

Query: Qry Product List

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

Tables Referenced

  • Product Status
  • Products

Columns Selected

  • Products.[Product ID]
  • Product
  • Products.[Product Status ID]
  • [Product Status].[Product Status]
  • Products.[Date Created]
  • Products.[Version Number]

SQL

SELECT Products.[Product ID], Products.Product, Products.[Product Status ID], [Product Status].[Product Status], Products.[Date Created], Products.[Version Number] FROM [Products], [Product Status]