Skip to content

Query: Qry SubRpt Principals Sales Contacts

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

Tables Referenced

  • Contact Type LkUp
  • Principals Sales Contacts
  • Principals

Columns Selected

  • [Principals Sales Contacts].[Principal ID]
  • [Contact Type LkUp].[Contact Type]
  • [Contact First Name] & \
  • [Principals Sales Contacts].[Contact Position]
  • [Principals Sales Contacts].[Contact Email]
  • [Principals Sales Contacts].[Contact Phone]
  • [Principals Sales Contacts].[Contact Cell Phone]

SQL

SELECT [Principals Sales Contacts].[Principal ID], [Contact Type LkUp].[Contact Type], [Contact First Name] & \, [Principals Sales Contacts].[Contact Position], [Principals Sales Contacts].[Contact Email], [Principals Sales Contacts].[Contact Phone], [Principals Sales Contacts].[Contact Cell Phone] FROM [Principals Sales Contacts], [Contact Type LkUp]