I have a table of transactions for which I want to query and get a list of unique customer IDs and their names (The ID needs to be unique, not the name). Can you tell me if the code below will do what I want it to (query to find a list of unique customer IDs) or is it really looking for a unique combination of CustomerID and Customer Name?
Expand|Select|Wrap|Line Numbers
- SELECT DISTINCTROW
- tbl_PRODetail.[Customer ID],
- tbl_PRODetail.[Customer Name]
- FROM tbl_PRODetail;