Skip to content

Query: Qry Report Entrepreneurs Invoice Requested

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

Tables Referenced

  • Products
  • Entrepreneur Company
  • Entrepreneurs
  • Delivery Locations

Columns Selected

  • Entrepreneurs.[Process Status ID]
  • [First Name] & \
  • [Entrepreneur Company].[Company Name]
  • Product
  • [Delivery Locations].[Delivery Location]
  • OwnedBy
  • Entrepreneurs.[Date Status Changed]

Where Clause

(((Entrepreneurs.[Process Status ID])=66))

SQL

SELECT Entrepreneurs.[Process Status ID], [First Name] & \, [Entrepreneur Company].[Company Name], Products.Product, [Delivery Locations].[Delivery Location], Entrepreneurs.OwnedBy, Entrepreneurs.[Date Status Changed] FROM [Entrepreneurs], [Products], [Entrepreneur Company], [Delivery Locations] WHERE (((Entrepreneurs.[Process Status ID])=66))