Part 14 - Return unique
records (no duplicate records)
To
return a set of records that contain only one of each unique
entry within a field, add DISTINCT to the SQL command.
You must use SQL View, not Query view.
This query returns the names of the products for which orders
have been placed.
SELECT Distinct Products.ProductName FROM Products,
Order_Details WHERE
(Products.ProductID=Order_Details.ProductID)
To compare result sets, click the TEST button using a query
with and then without the DISTINCT operator.