query help

[dvraggs]

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

 

[psemianonymous]

What is the question? From what you wrote, it looks like everything works fine. Good work.

 

[dvraggs]

the question is how to query single row with each item side by side like order#,item,item,item,amount

 

[psemianonymous]

Oh, you need to build a crosstab query. It will sum up (or count) everything of each category. Yeah, crosstab query will do what you want.