Oracle has the connect by and start with commands. Does SQL Server 2000 have the ability to query tables with a hierarchial relationship like Oracle does?