SQL Query Recursion Help Needed

// I need to write a query to extract data from two tables where I save information on my tables in one and the relationship between the tables in the second.

//CREATE TABLE [dbo].[tblPages](

// [PageID] [int] NOT NULL,

// [PagePath] [varchar](max) ,

// [MenuName] [nchar](10),

// [Directory] [varchar](15))

//CREATE TABLE [dbo].[tblPageRelation](

// [PageRelationshipID] [int] NOT NULL,

// [TopPageID] [int] NOT NULL,

// [BasePageID] [int] NOT NULL)

// What I would like to do is do the following in SQL is a combination of this

// SELECT * FROM TblPageRelation PR LEFT OUTER JOIN TblPages P on PR.TopPageID = P.PageID

//WHERE P.DIRECTORY = 'MENUBLOCK' UNION SELECT * FROM TblPageRelation PR LEFT OUTER JOIN TblPages P on PR.TopPageID = P.PageID

//WHERE P.DIRECTORY = P.DIRECTORY

//public void recursivemove (String Directory)

// {// Find Rows that Have this Block Name associated with em

// For each returned row find the rows that share the same Directory

// }

//}