>Oops, the subject should read:
>If some detail does not match, throw the header out
>
>
>Hello everybody.
>
>i've got 2 tables: sales order header (comast) and sales order detail (codet). i would like to display only sales orders where ALL of the details match certain criteria.
>
>i already have 2 scenarios completed:
>1. show sales orders which contain some/all details matching the criteria (show all detail lines)
>2. show sales orders which contain some/all details matching the criteria (show only matching detail lines)
>
>but the 3rd one i can not figure out the sql command. for the 1st scenario i prequerry the detail table by simply returning a new header with the orders containing anywhere the criteria.
>
>how do i do this?
>
>thank you for all your help.

could you post relevant table structures, some sample data, and the desired results from that sample data?