[thelist] More ASP/database questions...

Umm... don't you need a JOIN in there somewhere?

-----Original Message-----


the best way is to let the database do all the work

   select  category, subcat
     from tableA, tableB
    where tableB.categoryID = tableA.categoryID
   order by category, subcat