首页 > 代码库 > 同表自更新

同表自更新

update Project set Project.ProjectName=a.ProjectName+Project.ProjectNamefrom Project as a,Project where Project.ParentID=a.ID