select distinct parentTerritoryId from request.qmd_userTerritoryHierarchy where localMarket = 1 select * from request.qmd_userTerritoryHierarchy where localMarket = 1 or territoryId in ( ) select fspro_userid from tbl_fspro_members where fspro_userid < 100