Is it possible to create a search query that finds documents linked to multiple physical products?

For example, when searching for physical products SW-00002801 and SW-00002802, the result should return the document "Specification Bottle", since it is associated with both products.