ALL, DISTINCT, DISTINCTROW Predicates Examples

The following examples use two tables, Customers and Orders.

Customers Table

First Name Customer ID

Bob 1

Adam 2

Beverly 3

Bob 4

Orders Table

Customer ID Order ID

1 1

1 2

2 3

2 4

2 5

4 6

4 7

SQL statement

Result

Updatable

SELECT ALL [First Name] FROM Customers, Orders, Customers INNER JOIN Orders ON Customers.[Customer ID] = Orders.[Customer ID]	Bob Bob Adam Adam Adam Bob Bob	No
SELECT DISTINCT [First Name] FROM Customers, Orders, Customers INNER JOIN Orders ON Customers.[Customer ID] = Orders.[Customer ID]	Bob Adam	No
SELECT DISTINCTROW [First Name] FROM Customers, Orders, Customers INNER JOIN Orders ON Customers.[Customer ID] = Orders.[Customer ID]	Bob Adam Bob	Yes