Usenet.com

www.Usenet.com

Group Index

Comp Thread Archive from Usenet.com

<-- __Chronological__ --> <-- __Thread__ -->

Query property 'Unique records'



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__ -->


Usenet.com



Please check out one of the premium Usenet Newsgroup Service Providers below for access to Usenet.