sql中递归查询
with AA as ( select * from tb_ClientBranch_Category where BRANCH_MOM_NAME='北京易华录信息技术股份有限公司' union all select a2.* from AA inner join tb_ClientBranch_Category a2 on a2.BRANCH_MOM_NAME=AA.Branch_Name ) select * from AA
with as 作为临时结果集
如果觉得现在晚了,那么现在还来得及。