Skip to content

Query: JBQry Current Raizcorp Possibles by Delivery Location

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

Tables Referenced

  • Qry Get Division Dist Model Del Loc and Rec Info by Company
  • Entrepreneur Company
  • Delivery
  • Delivery Locations

Columns Selected

  • [Entrepreneur Company].[Company Delivery Location ID]
  • [Delivery Locations].[Delivery Location]
  • [Entrepreneur Company].[Company Name]
  • [Entrepreneur Company].[Entrepreneur Company ID]
  • [Qry Get Division Dist Model Del Loc and Rec Info by Company].[Pipeline ID]
  • [Entrepreneur Company].[Company Status ID]

Where Clause

((([Qry Get Division Dist Model Del Loc and Rec Info by Company].[Pipeline ID])=

Order By

[Delivery Locations].[Delivery Location]

SQL

SELECT [Entrepreneur Company].[Company Delivery Location ID], [Delivery Locations].[Delivery Location], [Entrepreneur Company].[Company Name], [Entrepreneur Company].[Entrepreneur Company ID], [Qry Get Division Dist Model Del Loc and Rec Info by Company].[Pipeline ID], [Entrepreneur Company].[Company Status ID] FROM [Delivery Locations], [Qry Get Division Dist Model Del Loc and Rec Info by Company], [Entrepreneur Company] WHERE ((([Qry Get Division Dist Model Del Loc and Rec Info by Company].[Pipeline ID])=