Listing Category then Items
Can somebody please give me some advise on how to implement this, I can do the easy SQL statements, but I get lost on the complex ones and what I've tried doesn't work or I know there is a better way, I just don't know it. I am using ASP, SQL Server. Right now I have one table where I want to select all the Categories and Items and have them display as in my sample, without the categories repeating.
SELECT Category, Item FROM Table1 WHERE Start_Date <= '" & Date & "';
This is how I would like it to display
Can this work with one table or should I make another table then select the category and do some kind of Join statement, also some Categories might not have any Items for that day.
Any help would be appreciated, Thanks in advance.