SELECT distinct t.territoryid, t.name, t.name territoryName, tl.brokerLevel, tl.Rank, t.parentTerritoryID, t.primaryManager FROM tbl_TER_Territories t INNER JOIN tbl_TER_TerritoryLevels tL ON tl.levelid = t.levelid AND tl.ownerID = t.ownerID AND tl.FSL_TableCode = t.fsl_tablecode INNER JOIN tbl_TER_Territories pt ON (pt.territoryID = t.parentTerritoryID OR pt.territoryID = t.territoryID ) AND pt.ownerID = t.ownerID AND pt.FSL_TableCode = t.fsl_tablecode INNER JOIN tbl_TER_TerritoryLevels ptl ON ptl.levelid = pt.levelID AND ptl.ownerid = pt.ownerID AND ptl.fsl_tablecode = pt.fsl_tablecode INNER JOIN tbl_TER_TerritoryLevels ptlcl ON ptlcl.parentLevelId = ptl.levelId AND ptlcl.ownerid = ptl.ownerID AND ptlcl.fsl_tablecode = ptl.fsl_tablecode AND ptlcl.brokerlevel = 1 WHERE pt.ownerID = AND pt.fsl_tablecode = AND pt.primarymanager = ORDER BY tl.rank ASC, t.name select ownerid, fsl_tablecode, staffmember from tbl_fspro_members where fspro_userid = SELECT distinct pt.territoryid, pt.name, pt.name territoryName, ptl.brokerLevel, ptl.Rank, pt.parentTerritoryID, pt.primaryManager FROM tbl_TER_Territories t INNER JOIN tbl_TER_Territories pt ON pt.territoryID = t.parentTerritoryID AND pt.ownerID = t.ownerID AND pt.FSL_TableCode = t.fsl_tablecode INNER JOIN tbl_TER_TerritoryLevels ptL ON ptl.levelid = pt.levelid AND ptl.ownerID = pt.ownerID AND ptl.FSL_TableCode = pt.fsl_tablecode INNER JOIN tbl_SMA_BrokerOfficeLink bol ON bol.mfr_id = t.ownerID AND bol.territoryid = t.territoryID WHERE t.ownerid = and t.fsl_tablecode = and bol.brokerid = union SELECT distinct t.territoryid, t.name, t.name territoryName, tl.brokerLevel, tl.Rank, t.parentTerritoryID, t.primaryManager FROM tbl_TER_Territories t INNER JOIN tbl_TER_TerritoryLevels tL ON tl.levelid = t.levelid AND tl.ownerID = t.ownerID AND tl.FSL_TableCode = t.fsl_tablecode INNER JOIN tbl_SMA_BrokerOfficeLink bol ON bol.mfr_id = t.ownerID AND bol.territoryid = t.territoryID WHERE t.ownerid = and t.fsl_tablecode = and bol.brokerid = order by rank asc, 2 SELECT t.territoryid, t.name, t.name territoryName, tl.brokerLevel, tl.Rank, t.parentTerritoryID, t.primaryManager FROM tbl_TER_Territories t INNER JOIN tbl_TER_TerritoryLevels tL ON tl.levelid = t.levelid AND tl.ownerID = t.ownerID AND tl.FSL_TableCode = t.fsl_tablecode WHERE 1 = 2