SELECT t.TerritoryID FROM tbl_TER_Territories t WHERE t.OwnerID = AND t.FSL_TableCode = AND t.parentTerritoryId IN ( ) SELECT t.TerritoryID FROM tbl_TER_Territories t WHERE t.OwnerID = AND t.FSL_TableCode = SELECT t.TerritoryID, t.Name territoryName, l.rank, l.brokerLevel, t.parentTerritoryId FROM tbl_TER_Territories t INNER JOIN tbl_TER_TerritoryLevels l ON l.levelid = t.levelid AND l.ownerId = t.ownerId AND l.FSL_TableCode = t.FSL_TableCode WHERE t.OwnerID = AND t.FSL_TableCode = AND t.territoryId IN () ORDER BY l.rank, t.territoryName