UniqueRecords Property Example

The query in this example returns a list of customers from the Customers table who have at least one order in the Orders table.

Customers Table

Orders Table

The following SQL statement returns the customer names in the following table:

SELECT DISTINCTROW Customers.CompanyName, Customers.CustomerID
FROM Customers INNER JOIN Orders
ON Customers.CustomerID = Orders.CustomerID;