Skip to content

Query: Qry Count Unallocated Companies by Principal Project Recommended

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

Tables Referenced

  • Qry Get Division Dist Model and Rec Info by Company
  • Qry
  • Entrepreneur Company

Columns Selected

  • [Qry Get Division Dist Model and Rec Info by Company].[Recommended Principal Pro
  • Count([Qry Get Division Dist Model and Rec Info by Company].[Entrepreneur Compan

Where Clause

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

SQL

SELECT [Qry Get Division Dist Model and Rec Info by Company].[Recommended Principal Pro, Count([Qry Get Division Dist Model and Rec Info by Company].[Entrepreneur Compan FROM [Qry Get Division Dist Model and Rec Info by Company], [Entrepreneur Company] WHERE ((([Entrepreneur Company].[Company Status ID])=2 Or ([Entrepreneur Company].[Com