hello, I have a table I take order. that table uses item key to look up item on other table. One order might appear twice because two items. this work great for everything i do, but look at orders with same items and different order amounts. I though about decode but there are over 100 itmes. any help would be great.
thanks
thanks