I have two tables: Prodycts & Category. What I wnt to do is simple but it seems like I just can't get it. I want to show a list of all the categoriea I have in the Category table which I know how to do but I want to show the list of products that belong to each cateogry in the following order.
I tried to get that thing done in so many different way but I'm not what will be the right one. I used Inner Join but it didn't worked out... What can I do? I'm out of my mind...