Skip to content

Query: Qry Report Company Profile Merge Data

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

Tables Referenced

  • Entrepreneur
  • Qry Get Entrepreneur Info for Projile Merge
  • Entrepreneur Company
  • IndustryLookup
  • Qry Count Entrepreneurs by Company for Projile

Columns Selected

  • [Entrepreneur Company].[Entrepreneur Company ID]
  • [Qry Count Entrepreneurs by Company for Projile].[Number of Entrepreneurs]
  • [Entrepreneur Company].[Company Name]
  • [Entrepreneur Company].[Brief Description of Business]
  • Industry
  • [Entrepreneur Company].[Average Monthly Turnover]
  • [Entrepreneur Company].[BEE Level]
  • [Entrepreneur Company].[Percentage Black Owned]
  • [Entrepreneur Company].[Percentage Women Black Owned]

Where Clause

((([Entrepreneur Company].[Company Status ID])=1 Or ([Entrepreneur Company].[Com

Order By

[Entrepreneur Company].[Company Name]

SQL

SELECT [Entrepreneur Company].[Entrepreneur Company ID], [Qry Count Entrepreneurs by Company for Projile].[Number of Entrepreneurs], [Entrepreneur Company].[Company Name], [Entrepreneur Company].[Brief Description of Business], IndustryLookup.Industry, [Entrepreneur Company].[Average Monthly Turnover], [Entrepreneur Company].[BEE Level], [Entrepreneur Company].[Percentage Black Owned], [Entrepreneur Company].[Percentage Women Black Owned] FROM [Entrepreneur Company], [Qry Count Entrepreneurs by Company for Projile], [IndustryLookup], [Qry Get Entrepreneur Info for Projile Merge] WHERE ((([Entrepreneur Company].[Company Status ID])=1 Or ([Entrepreneur Company].[Com