Skip to content

Query: Qry Get Principal Marketing Contact by Sales Brief

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

Tables Referenced

  • Sales
  • Principals Sales Contacts
  • Sales Brief
  • Principals Sales

Columns Selected

  • [Sales Brief].[Sales Brief ID]
  • [Principals Sales Contacts].[Contact Type ID]
  • [Contact First Name] & \
  • [Principals Sales Contacts].[Contact Email]
  • [Principals Sales Contacts].[Contact Phone]

Where Clause

((([Principals Sales Contacts].[Contact Type ID])=5))

SQL

SELECT [Sales Brief].[Sales Brief ID], [Principals Sales Contacts].[Contact Type ID], [Contact First Name] & \, [Principals Sales Contacts].[Contact Email], [Principals Sales Contacts].[Contact Phone] FROM [Sales Brief], [Principals Sales], [Principals Sales Contacts] WHERE ((([Principals Sales Contacts].[Contact Type ID])=5))