I am having a problem with an SQL Select joining 3 tables.
First I tried it out using only 2 tables:

 SELECT Customers.orderid, Customers.datesold, Customers.firstname,;
  Customers.lastname, OrderDTL.prodno, OrderDTL.quantity, OrderDTL.saleprice;
 FROM ;
     MYDBC!OrderDTL ;
    INNER JOIN MYDBC!CUSTOMERS ;
   ON  OrderDTL.orderid = Customers.orderid;
 WHERE  Customers.datesold = ( ?ddate );
 ORDER BY Customers.lastname, Customers.firstname

This code obtains the correct number of records for each date I enter for DDATE

Now I add the one field I need from the third table to this Select: products.prodname

SELECT Customers.orderid, Customers.datesold, Customers.firstname,;
  Customers.lastname, OrderDTL.prodno, OrderDTL.quantity, OrderDTL.saleprice, products.prodname;
 FROM ;
     MYDBC!OrderDTL ;
    INNER JOIN MYDBC!CUSTOMERS ;
   ON  OrderDTL.orderid = Customers.orderid;
   INNER JOIN MYDBC!PRODUCTS ;
   ON OrderDTL.prodno = Products.prodno;
 WHERE  Customers.datesold = ( ?ddate );
 ORDER BY Customers.lastname, Customers.firstname

But the results are that I get one duplicated record for each date I try. Only 1 record appears twice while all the other records appear only once.

Is this a VFP/SQL quirk or what am doing wrong?

Thanks
Raymond Larche