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.