Skip to content

Query: Qry SubRpt EOI Entrepreneur Company

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

Tables Referenced

  • IndustryLookup
  • Entrepreneur
  • Entrepreneur Company

Columns Selected

  • [Entrepreneur Company].[Entrepreneur Company ID]
  • [Entrepreneur Company].[Company Name]
  • [Entrepreneur Company].[Business Address 1]
  • [Entrepreneur Company].[Business Address 2]
  • [Entrepreneur Company].[Business Address 3]
  • [Entrepreneur Company].[Business Postal Code]
  • Website
  • Industry
  • [Entrepreneur Company].[Brief Description of Business]
  • [Entrepreneur Company].[Average Monthly Turnover]
  • [Entrepreneur Company].[Years in Business]
  • [Entrepreneur Company].[Date Business Started]
  • [Entrepreneur Company].[Permanent Employees]
  • [Entrepreneur Company].[Temporary Employees]
  • CompanyReg
  • [Entrepreneur Company].[Enterprise Type]
  • [Entrepreneur Company].[Trading As]
  • [Entrepreneur Company].[BEE Certificate Expire Date]
  • [Entrepreneur Company].[Tax Clearance Expire Date]
  • [Entrepreneur Company].[BEE Level]
  • [Entrepreneur Company].[BEE Certificate Type]
  • [Entrepreneur Company].[Percentage Black Owned]
  • [Entrepreneur Company].[Percentage Women Black Owned]
  • [Entrepreneur Company].[Special Accreditations]
  • [Entrepreneur Company].[Business Premises]
  • [Entrepreneur Company].[Business Premises Other]
  • [Entrepreneur Company].[Monthly Premises Rental]
  • [Entrepreneur Company].[Premises Square Meters]
  • IIf([Equipment Insurance]=True,\
  • [Entrepreneur Company].[Equipment Insurance Amt]
  • IIf([Personal Vehicle Insurance]=True,\
  • [Entrepreneur Company].[Personal Vehicle Insurance Amt]
  • IIf([Business Vehicle Insurance]=True,\
  • [Entrepreneur Company].[Business Vehicle Insurance Amt]
  • IIf([Loss of Earnings Insurance]=True,\
  • [Entrepreneur Company].[Loss of Earnings Insurance Amt]
  • IIf([Stock Insurance]=True,\
  • [Entrepreneur Company].[Stock Insurance Amt]
  • IIf([Forex Insurance]=True,\
  • [Entrepreneur Company].[Forex Insurance Amt]
  • IIf([Life Insurance]=True,\
  • [Entrepreneur Company].[Life Insurance Amt]
  • IIf([Personal Medical Aid]=True,\
  • [Entrepreneur Company].[Personal Medical Aid Amt]
  • IIf([Staff Medical Aid]=True,\
  • [Entrepreneur Company].[Staff Medical Aid Amt]
  • IIf([Other Insurance]=True,\
  • [Entrepreneur Company].[Other Insurance Amt]
  • [Entrepreneur Company].[Other Insurance Explanation]
  • IIf([Own Bookkeeper]=True,\
  • [Entrepreneur Company].[Bookkeeper Avg Monthly Cost]
  • [Entrepreneur Company].[Bookkeeper Rating]
  • [Entrepreneur Company].[Bookkeeper Name]
  • [Entrepreneur Company].[Bookkeeper Software]
  • [Entrepreneur Company].[Other Software Explanation]

SQL

SELECT [Entrepreneur Company].[Entrepreneur Company ID], [Entrepreneur Company].[Company Name], [Entrepreneur Company].[Business Address 1], [Entrepreneur Company].[Business Address 2], [Entrepreneur Company].[Business Address 3], [Entrepreneur Company].[Business Postal Code], [Entrepreneur Company].Website, IndustryLookup.Industry, [Entrepreneur Company].[Brief Description of Business], [Entrepreneur Company].[Average Monthly Turnover], [Entrepreneur Company].[Years in Business], [Entrepreneur Company].[Date Business Started], [Entrepreneur Company].[Permanent Employees], [Entrepreneur Company].[Temporary Employees], [Entrepreneur Company].CompanyReg, [Entrepreneur Company].[Enterprise Type], [Entrepreneur Company].[Trading As], [Entrepreneur Company].[BEE Certificate Expire Date], [Entrepreneur Company].[Tax Clearance Expire Date], [Entrepreneur Company].[BEE Level], [Entrepreneur Company].[BEE Certificate Type], [Entrepreneur Company].[Percentage Black Owned], [Entrepreneur Company].[Percentage Women Black Owned], [Entrepreneur Company].[Special Accreditations], [Entrepreneur Company].[Business Premises], [Entrepreneur Company].[Business Premises Other], [Entrepreneur Company].[Monthly Premises Rental], [Entrepreneur Company].[Premises Square Meters], IIf([Equipment Insurance]=True,\, [Entrepreneur Company].[Equipment Insurance Amt], IIf([Personal Vehicle Insurance]=True,\, [Entrepreneur Company].[Personal Vehicle Insurance Amt], IIf([Business Vehicle Insurance]=True,\, [Entrepreneur Company].[Business Vehicle Insurance Amt], IIf([Loss of Earnings Insurance]=True,\, [Entrepreneur Company].[Loss of Earnings Insurance Amt], IIf([Stock Insurance]=True,\, [Entrepreneur Company].[Stock Insurance Amt], IIf([Forex Insurance]=True,\, [Entrepreneur Company].[Forex Insurance Amt], IIf([Life Insurance]=True,\, [Entrepreneur Company].[Life Insurance Amt], IIf([Personal Medical Aid]=True,\, [Entrepreneur Company].[Personal Medical Aid Amt], IIf([Staff Medical Aid]=True,\, [Entrepreneur Company].[Staff Medical Aid Amt], IIf([Other Insurance]=True,\, [Entrepreneur Company].[Other Insurance Amt], [Entrepreneur Company].[Other Insurance Explanation], IIf([Own Bookkeeper]=True,\, [Entrepreneur Company].[Bookkeeper Avg Monthly Cost], [Entrepreneur Company].[Bookkeeper Rating], [Entrepreneur Company].[Bookkeeper Name], [Entrepreneur Company].[Bookkeeper Software], [Entrepreneur Company].[Other Software Explanation] FROM [Entrepreneur Company], [IndustryLookup]