Skip to content

Query: Qry Report Opal Prin Proj Summary Weighted EPs and Comp by DL

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

Tables Referenced

  • SubQry Rpt Opal Prin Proj Summary Count Weighted EPs by Del Loc
  • SubQry Rpt Opal Prin Proj Summary Count Weighted Comp by Del Loc
  • SubQry

Columns Selected

  • [SubQry Rpt Opal Prin Proj Summary Count Weighted EPs by Del Loc].[Company Deliv
  • [SubQry Rpt Opal Prin Proj Summary Count Weighted EPs by Del Loc].[Delivery Loca
  • [SubQry Rpt Opal Prin Proj Summary Count Weighted EPs by Del Loc].[Number EPs]
  • [SubQry Rpt Opal Prin Proj Summary Count Weighted Comp by Del Loc].[Number Compa
  • [SubQry Rpt Opal Prin Proj Summary Count Weighted Comp by Del Loc].[Weighted Num

Order By

[SubQry Rpt Opal Prin Proj Summary Count Weighted EPs by Del Loc].[Delivery Loca

SQL

SELECT [SubQry Rpt Opal Prin Proj Summary Count Weighted EPs by Del Loc].[Company Deliv, [SubQry Rpt Opal Prin Proj Summary Count Weighted EPs by Del Loc].[Delivery Loca, [SubQry Rpt Opal Prin Proj Summary Count Weighted EPs by Del Loc].[Number EPs], [SubQry Rpt Opal Prin Proj Summary Count Weighted Comp by Del Loc].[Number Compa, [SubQry Rpt Opal Prin Proj Summary Count Weighted Comp by Del Loc].[Weighted Num FROM [SubQry Rpt Opal Prin Proj Summary Count Weighted Comp by Del Loc], [SubQry Rpt Opal Prin Proj Summary Count Weighted EPs by Del Loc]