Skip to content

Query: SubQry Purchased ED vs SD Report S2S

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

Tables Referenced

  • SubQry Purchased ED vs SD Report S2S Criteria
  • SubQry Purchased ED vs SD Report SDM
  • SubQry

Columns Selected

  • [SubQry Purchased ED vs SD Report S2S Criteria].[Principal Project ID]
  • [SubQry Purchased ED vs SD Report S2S Criteria].[Principal Project]
  • [SubQry Purchased ED vs SD Report S2S Criteria].[Client Tier]
  • FYE

Where Clause

((([SubQry Purchased ED vs SD Report SDM].[Principal Project ID]) Is Null))

Order By

[SubQry Purchased ED vs SD Report S2S Criteria].[Principal Project]

SQL

SELECT [SubQry Purchased ED vs SD Report S2S Criteria].[Principal Project ID], [SubQry Purchased ED vs SD Report S2S Criteria].[Principal Project], [SubQry Purchased ED vs SD Report S2S Criteria].[Client Tier], [SubQry Purchased ED vs SD Report S2S Criteria].FYE FROM [SubQry Purchased ED vs SD Report SDM], [SubQry Purchased ED vs SD Report S2S Criteria] WHERE ((([SubQry Purchased ED vs SD Report SDM].[Principal Project ID]) Is Null))