Hi all, I have a table with two columns that the first column is box name and the second column name is product name and I want to select products that is common in all boxes, for example :
box.................product
box4.................. E
box1.................. A
box2.................. B
box3.................. C
box1.................. D
box4.................. A
box3.................. A
box2.................. D
box2.................. A
box2.................. E
result of query :
Product
A
Can I create the query?
box.................product
box4.................. E
box1.................. A
box2.................. B
box3.................. C
box1.................. D
box4.................. A
box3.................. A
box2.................. D
box2.................. A
box2.................. E
result of query :
Product
A
Can I create the query?