Listing Items Under Categories

Let's say that I have the following tables in a database:

Categories: CategoryID, Category

Products: ProductID, CategoryID, ProductName

Let's say that there are 4 categories. I would like to divide the products into 4 categories on a web page.

I would like for it to look something like this:

Gifts

ProductName

ProductName

Ornaments

ProductName

ProductName

I know that I could accomplish this by creating 4 different recordsets on the web page. But I wonder if there is a way to do this with only one recordset. Can someone please help me with this? Does this make sense?

I'm lost. I am not sure how to do this. I have no problems with joining the tables and sorting them. I have tried different things. Please look at the below code:

      'Start sql string with Join

     sqlString = "select * from Category, Products"

     sqlString = sqlString & " where Category.CategoryID=Products.CategoryID order by Category, ProductName"

     'Create the recordset

      set rs = Server.CreateObject("ADODB.Recordset")

      rs.Open sqlString, connectionString, adOpenDynamic, adLockOptimistic

%>   

I want the Category to show up here. But I have been unsuccessful so far. I would like for the category to display only one time for a section of products that are under this category. I need some help with the code.

      <!-- Draw the table headings -->

      <TABLE BORDER=1>

      <TR>

           <TH>ProductName</TH>

           <TH>Description </TH>

      </TR>

<% 

           'Set the current record pointer to the first record of the recordset

           rs.MoveFirst

           'Loop through all the records in the recordset

           while not rs.EOF

                 'Get values

                 Category = rs("Category") & ""

                 ProductName = rs("ProductName") & ""

                 Description = rs("Description") & ""