I have a table called categories. Basically the way our system works is you can have infinite subcategories for one category. So an example would be<BR><BR>pc->hardware->hard drives->western digital<BR><BR>The way that they link is that each category has a ParentCategoryID. The table relates to itself. <BR><BR>Table Categories<BR>CategoryID CatName ParentCategoryID<BR><BR>So it nests... I cant figure out givin a categoryID how to find all parentCategory's or all child categories. THe only solution I could figure out is to use a while loop in a stored procedure doing multiple select statements with a temporary table. I was hoping there would be a way to do it with one statement.