Hi there - I have a table that has details of customer orders. I'm trying to find orders that are the same so that I can pick them quicker - ie out of 3,000 orders, there may be 5 orders where all customers have ordered apples, oranges and peaches (quantity is not important, just the product ID)
table includes fields - orderID, qtyOrd, ProductID, customerID
want to return preferabley something that has a new ID called orderSet which is a number that groups all similar orders
any help very appreciated!!