Hello,
I have three tables

tblNews
NewsID
NewsTitle

tblCategory
CategoryID
CategoryName

tblNewsCategory
NCID
NCNewsID
NCCategoryID

Each news story will have 1 or more categories associated with it.

I would like to produce output that looks like
Categories: NewsTitle
CategoryName1, CategoryName 7, ... CategoryNamex This is News Story 1
CategoryName2 This is News Story 2
CategoryName5, CategoryName11 This is News Story 3

Should I handle creating the list of categories in code can I do it in a query?
I am using mysql so stored procedures are not an option at the moment for me.

Thanks,
CodeChimp