so I have a database and its setup this way.

I have a Categories table and then inside that are 4 more categories called learn, listen, create, and record. inside those 4 categories are 3 more categories in each record; called: good, better, best.

Then inside each one of good, better, and best is a product or item.

I am new to coldfusion and sql. how do i display the product that is in one of those good, better, or best folders.

I have tried many different ways, cant figure it out.

thanks