
www.Usenet.com
| <-- __Chronological__ --> | <-- __Thread__ --> |
I do not quite understand this property. Everything is clear to me, when I read the corresponding help text. But in practice I have a question: Why are there 3 identical records in the following query (with property 'Unique records' = Yes)? SELECT DISTINCTROW tblCustomer.[Customer ID], tblCustomer.[Company Name], tblCustomer.[Locatiion Code], tblOrders.[Customer ID], tblOrders.[Order ID], tblOrders.Artikel FROM tblCustomer INNER JOIN tblOrders ON tblCustomer.[Customer ID] = tblOrders.[Customer ID]; Can you help me? Thanks. Beat Scheidiger
| <-- __Chronological__ --> | <-- __Thread__ --> |