---> SELECT cdr.cdr_territoryID, t.parentTerritoryID FROM tbl_CDR_Distributors cdr INNER JOIN tbl_TER_Territories t ON t.territoryid = cdr.cdr_territoryId AND t.ownerID = cdr.ownerid AND t.fsl_tablecode = cdr.fsl_tablecode WHERE cdr.cdr_recordid = AND cdr.ownerid = AND cdr.fsl_tablecode = SELECT territoryid, name, territoryName, brokerLevel, Rank, parentTerritoryID, primaryManager FROM qcf_getUserTerritories WHERE brokerLevel = 1 SELECT distinct parentTerritoryId FROM qmd_listBrokerMrkts WHERE brokerLevel = 1 SELECT territoryid, name, territoryName, brokerLevel, Rank, parentTerritoryID, primaryManager FROM qcf_getUserTerritories WHERE brokerlevel <> 1 ---> ---> ---> ---> ---> ---> ---> ---> --->