2个表之间的批量update问题！急。。。。。

[dragon514]

Update Contract Set ContractNo=Contract_Temp.ContractNo,
ContractName=Contract_Temp.ContractName,
SignOther=Contract_Temp.SignOther,
CONTRACTSUM=Contract_Temp.CONTRACTSUM,
ONEFEE=Contract_Temp.ONEFEE,
MONTHFEE=Contract_Temp.MONTHFEE
From Contract,Contract_Temp
Where Contract.ContractID=Contract_Temp.ContractID

SQL中能这么写，但是ORACLE中一定要每个
set a = select a from TabB where ....
这样吗？有没有简单点的？

[hsj20041004]

不用的

eg:
Update Contract Set (ContractNo，
ContractName，SignOther，CONTRACTSUM，ONEFEE，MONTHFEE)=（select ContractNo,ContractNameFrom,SignOther,CONTRACTSUM ,ONEFEE,MONTHFEE from Contract_Temp
Where Contract.ContractID=Contract_Temp.ContractID)

[onejune4450]

Update Contract a
Set(ContractNo,ContractName,SignOther,CONTRACTSUM,ONEFEE,MONTHFEE)
=(SELECT ContractNo,ContractName,SignOther,CONTRACTSUM,ONEFEE,MONTHFEE
From Contract_Temp b
Where a.ContractID=b.ContractID)
需要时加
Update Contract a
Set(ContractNo,ContractName,SignOther,CONTRACTSUM,ONEFEE,MONTHFEE)
=(SELECT ContractNo,ContractName,SignOther,CONTRACTSUM,ONEFEE,MONTHFEE
From Contract_Temp b
Where a.ContractID=b.ContractID)
where exists ( select 1 from Contract_Temp c
where a.ContractID=c.ContractID)

[dragon514]

Update Contract Set (ContractNo，
ContractName，SignOther，CONTRACTSUM，ONEFEE，MONTHFEE)=（select ContractNo,ContractNameFrom,SignOther,CONTRACTSUM ,ONEFEE,MONTHFEE from Contract_Temp
Where Contract.ContractID=Contract_Temp.ContractID)
这样不对，我Contract表有1000条纪录，Contract_Temp有5条纪录，
这样运行的结果是把1000条都更新了

[qiansl]

请采用如下形式：
Update Contract a
Set(ContractNo,ContractName,SignOther,CONTRACTSUM,ONEFEE,MONTHFEE)
=(SELECT ContractNo,ContractName,SignOther,CONTRACTSUM,ONEFEE,MONTHFEE
From Contract_Temp b
Where a.ContractID=b.ContractID)
where exists ( select 1 from Contract_Temp c
where a.ContractID=c.ContractID)