I need to get some result details based on a seperate query result.
I have two tables, Order and OrderDetails.
I need to pick out all the orders in Orders that were ordered by the same Cust# on the same OrderDate. Sum (Orders > 1) .
Using those specific order numbers I need to pull out the orderdetails description.
I know this is a little vague but I think it describes the basic need. The results of one query will determine what is pulled by the second query.