Skip to content

Query: SubQry Rpt Opal Prin Proj Summary Comp Required _1 Del Loc

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

Tables Referenced

  • Principal
  • Qry Sum Companies Required by Principal Project
  • Principal Projects
  • Qry Count Delivery Locations Allowed by Principal Project

Columns Selected

  • [Qry Count Delivery Locations Allowed by Principal Project].[Number Del Loc Allo
  • [Principal Projects].[Principal Project Status ID]
  • [Principal Projects].[Principal Project ID]
  • [Qry Sum Companies Required by Principal Project].[Companies Required]

Where Clause

((([Qry Count Delivery Locations Allowed by Principal Project].[Number Del Loc A

SQL

SELECT [Qry Count Delivery Locations Allowed by Principal Project].[Number Del Loc Allo, [Principal Projects].[Principal Project Status ID], [Principal Projects].[Principal Project ID], [Qry Sum Companies Required by Principal Project].[Companies Required] FROM [Principal Projects], [Qry Sum Companies Required by Principal Project], [Qry Count Delivery Locations Allowed by Principal Project] WHERE ((([Qry Count Delivery Locations Allowed by Principal Project].[Number Del Loc A