Skip to content

Query: JB Qry Update Principal Countries

Type: Delete
Has Parameters: No
Has Joins: No
Has Subquery: No

Tables Referenced

  • Principals
  • Principals Sales

Columns Selected

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

Where Clause

((([Principals Sales].[Country ID]) Is Not Null))

SQL

SELECT [Principals Sales].[Principal ID], [Principals Sales].[Country ID] FROM [Principals Sales] WHERE ((([Principals Sales].[Country ID]) Is Not Null))