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.firstnameThis code obtains the correct number of records for each date I enter for DDATE
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.firstnameBut 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.