select territoryid from tbl_opr_clientoperators with (nolock) where ownerid = and fsltablecode = and operatorid = select * from qryPartnerSalesTeam where salesperson_ownerid = and salesperson_ownertype = order by lastname, firstname select * from qryPartnerSalesTeam where salesperson_ownerid <> or salesperson_ownertype <> order by lastname, firstname select broker_name from tblbrokers with (nolock) where broker_id =