Query: Qry Get Principal Projects for Purchased ED vs SD Report

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

Tables Referenced

• Entrepreneur
• Entrepreneur Company
• Principal Project Pillars
• Entrepreneur Company Programme Years
• Client Tiers
• Principal Projects
• Entrepreneur Company Principal Projects
• Entrepreneurs

Columns Selected

• [Principal Projects].[Principal Project ID]

Where Clause

((([Client Tiers].[Client Tier]) Is Not Null) AND (([Entrepreneur Company Progra

SQL

SELECT [Principal Projects].[Principal Project ID] FROM [Entrepreneur Company Programme Years], [Entrepreneur Company Principal Projects], [Principal Project Pillars], [Principal Projects], [Client Tiers], [Entrepreneur Company], [Entrepreneurs] WHERE ((([Client Tiers].[Client Tier]) Is Not Null) AND (([Entrepreneur Company Progra