I'm not sure if the title is relevant to the question, bu i didn't found a better one.
Here's the problem - I have 4 table, let's say:

products (id, product\_name),  

priceA(product\_id, price),  

priceB(product\_id, price),  

priceC (product\_id, price). 

What i need to do is write a select that will show me only products that have prices in priceA OR priceB OR priceC OR in any combination of a,b,c

How could I do this ? Thank you!