子查询一定要注意，别忘记加TOP 1，不然就GG了，过了好久测试给我测出来了

diaojianshi6729

于 2017-12-08 10:56:00 发布

阅读量223

点赞数

原文链接：http://www.cnblogs.com/tangpeng97/p/8004393.html

版权

            string sql = "select Code,DepartmentName"
                    + ",(select  top 1   OrgName from SysBest_Organization where TreeId = CompanyId ) as CompanyId"
                    + ",(select  top 1   OrgName from SysBest_Organization where TreeId = ParentDepartmentId ) as ParentDepartmentId"
                    + ",(select  top 1   OrgName from SysBest_Organization where TreeId = AdjustedParentCompanyId ) as AdjustedParentCompanyId"
                    + ",(select  top 1   OrgName from SysBest_Organization where TreeId = AdjustedParentDepartmentId ) as AdjustedParentDepartmentId"
                    + ", AdjustedCode,AdjustedDepartmentName,AdjustedDate,Regulator,VGUID from X6_Organization_DepartmentAdjust ";