Skip to content

Query: Qry Company Raizcorpossibles List

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

Tables Referenced

  • vwGarnetCompanyRaizcorpossiblesList

Columns Selected

  • vwGarnetCompanyRaizcorpossiblesList.[Entrepreneur Company ID]
  • vwGarnetCompanyRaizcorpossiblesList.[Process Status ID]
  • vwGarnetCompanyRaizcorpossiblesList.[Company Name]
  • vwGarnetCompanyRaizcorpossiblesList.[Company Delivery Location ID]
  • vwGarnetCompanyRaizcorpossiblesList.[Company Status ID]
  • Status
  • vwGarnetCompanyRaizcorpossiblesList.[Delivery Location]
  • vwGarnetCompanyRaizcorpossiblesList.[Sort Order]
  • vwGarnetCompanyRaizcorpossiblesList.[Status Change]
  • [First Name] & \
  • Division
  • vwGarnetCompanyRaizcorpossiblesList.[Distribution Model]
  • [Principal] & \
  • vwGarnetCompanyRaizcorpossiblesList.[Recommended Product]

SQL

SELECT vwGarnetCompanyRaizcorpossiblesList.[Entrepreneur Company ID], vwGarnetCompanyRaizcorpossiblesList.[Process Status ID], vwGarnetCompanyRaizcorpossiblesList.[Company Name], vwGarnetCompanyRaizcorpossiblesList.[Company Delivery Location ID], vwGarnetCompanyRaizcorpossiblesList.[Company Status ID], vwGarnetCompanyRaizcorpossiblesList.Status, vwGarnetCompanyRaizcorpossiblesList.[Delivery Location], vwGarnetCompanyRaizcorpossiblesList.[Sort Order], vwGarnetCompanyRaizcorpossiblesList.[Status Change], [First Name] & \, vwGarnetCompanyRaizcorpossiblesList.Division, vwGarnetCompanyRaizcorpossiblesList.[Distribution Model], [Principal] & \, vwGarnetCompanyRaizcorpossiblesList.[Recommended Product] FROM [vwGarnetCompanyRaizcorpossiblesList]