Skip to content

Query: Qry SubRpt Principals Sales Countries

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

Tables Referenced

  • CountryLookup
  • Principals Sales Countries

Columns Selected

  • [Principals Sales Countries].[Principal ID]
  • Country

SQL

SELECT [Principals Sales Countries].[Principal ID], CountryLookup.Country FROM [CountryLookup], [Principals Sales Countries]