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