Skip to content

Query: Qry Principal List

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

Tables Referenced

  • Principals
  • Principals Sales

Columns Selected

  • [Principals Sales].[Principal ID]
  • Principal
  • [Principals Sales].[Physical Address 1]
  • [Principals Sales].[Physical Address 2]

SQL

SELECT [Principals Sales].[Principal ID], [Principals Sales].Principal, [Principals Sales].[Physical Address 1], [Principals Sales].[Physical Address 2] FROM [Principals Sales]