求一个Update语句的写法，更新的某个字段从查询中取得

[shan__le]

Update ProRenamed set NewProjectName=('sdafsdaf'),OriginalProjectName=('从下句查询获得的ProjectName字段名')
where serialID='0000000021'

select ProjectID,ProjectName from Project where ProjectID='0000000001'

我想写成一句，我在一个工作流系统里面自动更新update语句，这个写成一句应该怎么写？

[ACMAIN_CHM]

update ProRenamed set NewProjectName='sdafsdaf',OriginalProjectName=(select ProjectName from Project where ProjectID='0000000001')
where serialID='0000000021'

或者

update ProRenamed inner join Project on ProRenamed.ProjectID=Project.ProjectID
set ProRenamed.NewProjectName='sdafsdaf',
ProRenamed.OriginalProjectName=Project.ProjectName
where ProRenamed.ProjectID='0000000001'

[vinsonshen]

Update  ProRenamed 
set NewProjectName=('sdafsdaf'),
OriginalProjectName=(select ProjectName from Project where ProjectID='0000000001') 
where serialID='0000000021' 

[shan__le]

这位大哥，你的❤好多啊，多谢帮助啊，我马上验证啊

[shan__le]

没人回答，我顶一下，下次就顶个肺了