well this is getting more complex again. Actually what I have to start with is a list of each order from the order table, but problem is the order table does not contain information about the product at all. Instead, the orderdetails table has that. So I have to incorporate the inner join statement into a select statement on the order table. Make sense?
What I'm starting with is this:
SELECT ID, OrderDate, ShipDate
WHERE BillToID= xxx
Is there a way to incorporate the other query that looks up the orderdetails table? Each row I need a field that says yes or no - a product from that order either does or does not belong to a category.