Putting things in order - PLEASE HELP ME...

[weee]

Hi There.

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.

Cars
Colors
instruments

    ford
    Fiat
    B.M.W

    red
    green
    black
    grey
    orange

    piano
    sax
    drums
    keyboard
    trumpet 

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...

Thanks!

[buntine]

You have asked this question three time in a different way. If someone has an answer for you, they will post.

Please dont ask (primarily) the same question over and over again.

Regards.

[weee]

someone got it... meaning, I thought maybe I wrote in a way that is confusing an dhard to understand. You can delete the other two before if you find it's the right thing to do.

[buntine]

Its OK for now. But in the future, if you need to clarify something, please do it in the same thread rather than beginning a new one.

Regards.

[weee]

.