Skip to content

Query: Qry Company List

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

Tables Referenced

  • vwGarnetCompanyList

Columns Selected

  • vwGarnetCompanyList.[Entrepreneur Company ID]
  • vwGarnetCompanyList.[Company Name]
  • vwGarnetCompanyList.[Company Delivery Location ID]
  • vwGarnetCompanyList.[Delivery Location]
  • vwGarnetCompanyList.[Company Status ID]
  • Status
  • vwGarnetCompanyList.[Sort Order]
  • vwGarnetCompanyList.[Status Change]

SQL

SELECT vwGarnetCompanyList.[Entrepreneur Company ID], vwGarnetCompanyList.[Company Name], vwGarnetCompanyList.[Company Delivery Location ID], vwGarnetCompanyList.[Delivery Location], vwGarnetCompanyList.[Company Status ID], vwGarnetCompanyList.Status, vwGarnetCompanyList.[Sort Order], vwGarnetCompanyList.[Status Change] FROM [vwGarnetCompanyList]