Skip to content

Query: JB Qry Update Procurement Contact

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

Tables Referenced

  • Principals Sales Contacts
  • Principals Sales
  • Principals

Columns Selected

  • [Principals Sales Contacts].[Contact First Name]
  • [Principals Sales Contacts].[Contact Surname]
  • [Principals Sales Contacts].[Contact Position]
  • [Principals Sales Contacts].[Contact Email]
  • [Principals Sales Contacts].[Contact Cell Phone]

Where Clause

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

SQL

SELECT [Principals Sales Contacts].[Contact First Name], [Principals Sales Contacts].[Contact Surname], [Principals Sales Contacts].[Contact Position], [Principals Sales Contacts].[Contact Email], [Principals Sales Contacts].[Contact Cell Phone] FROM [Principals], [Principals Sales], [Principals Sales Contacts] WHERE ((([Principals Sales Contacts].[Contact Type ID])=4))