quote:

---

Originally posted by dlmagers10

Ok, I have a question (problem) I am trying to using the IN operator to find the number and name of each customer that placed an order on October 23, 2010.

Tables ~

rep r has rep_num, last_name, first_name, street, city, state, zip, commission, rate.

customer c has customer_num, customer_name, street, city, state, zip, balance, credit_limit, rep_num.

orders o has order_num, order_date, customer_num.

order_line l has order_num, part_num, num_ordered, quoted_price.

part p has part_num, description, on_hand, class, warehouse, price.

So far I have:

SELECT c.CUSTOMER_NUM, c.CUSTOMER_NAME
FROM CUSTOMER C, orders o
WHERE
c.customer_num= o.customer_num and
o.ORDER_DATE IN
(SELECT o.order_date
FROM orders o
WHERE o.order_date = 10/23/2010);

still just getting the column heads: customer_num, customer_name.

---