I'm trying to figure out a query that will get a list of orders which will have the combination of product A and B, C and D , X and Y, etc. So I need a list that will show only orders that have the combinations specified. Something like the code bellow:

```
select order_id, product_name
from orders
where product in( A & B, C & D)
group by order_id

```