Skip to content

Query: Qry SubRpt Principals Sales

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

Tables Referenced

  • Principals
  • Client Tiers
  • IndustryLookupSales
  • Principals Sales

Columns Selected

  • [Principals Sales].[Principal ID]
  • Principal
  • [Physical Address 1] & IIf(IsNull([Physical Address 2]),\
  • [Principals Sales].[Company Website]
  • Industry
  • [Principals Sales].[Industry Charter]

SQL

SELECT [Principals Sales].[Principal ID], [Principals Sales].Principal, [Physical Address 1] & IIf(IsNull([Physical Address 2]),\, [Principals Sales].[Company Website], IndustryLookupSales.Industry, [Principals Sales].[Industry Charter] FROM [Principals Sales], [Client Tiers], [IndustryLookupSales]