I have table with three columns in it. First is
product_id linked to another table, second is
att_id with link to another table and last one is
val_id linked to different table.
There are rows with same
att_id combinations. Every
product_id can have different number of
val_id (as seen in below example). Table looks like:
My goal is to select
val_id is equal to
(1 AND 2). There can be more
val_ids based on user input.
So, expected result from example above should be:
I cannot figure it out since every
val_id combination is in different row.
So any help will be appreciated.