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.