SELECT t.territoryid, t.name
FROM tbl_TER_Territories t, tbl_TER_TerritoryLevels tL, tbl_TER_Territories t2
WHERE t.LevelID = tL.LevelID
AND tL.BrokerLevel = 1
AND t.ParentTerritoryID = t2.TerritoryID
AND t2.primarymanager =
AND t.OwnerID =
AND t.FSL_TableCode =
select t.territoryid, t.name
from tbl_SMA_BrokerOfficeLink bol
inner join tbl_TER_Territories t
ON t.territoryid = bol.territoryid
AND t.ownerID = bol.mfr_id
and t.fsl_tablecode = 'MFR'
where bol.MFR_ID =
and bol.BrokerID =