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