规则维护

select bi.branch_code,(select BRANCH_NAME from BRANCH_INFO where branch_code='8648'),bi.BRANCH_NAME from BRANCH_CODE_RELATION bcr,BRANCH_INFO bi
where  bcr.branch_code='8646' and bcr.relative_grade<0 and bcr.relative_branch_code=bi.branch_code
  and bi.BRANCH_LEVEL='03';