>I am trying to do a select from 2 related tables in a one to many relationship. The first table holds orders and the second holds products. I would like to select all orders from the first table only if a certian product does not show up on that order in the second table. The products table can hold many diffetent products for each order, can a single select statement be made to weed out any orders that may contain a specific product? I usually do this with a select on the order table, then scan through the results with selects to the products table and then scan through those results to flag orders that may contain a certian product.
>
>Any help is greatly appeciated
>
>TIA
SELECT Orders.* ;
FROM Orders ;
WHERE OrderID NOT IN (SELECT DISTINCT Product.OrderID ;
FROM Product ;
WHERE Product.Name = cWeDontWantThisProduct)
Jay