update t_cust a set a.cust_name=(select b.cust_name from v_backfee b where b.cust_cardid=a.cust_cardid) ;
这样写就对了: update T_Cust A set A.CUST_NAME= (select B.CUST_NAME from V_BackFee B where A.Cust_CardID=B.Cust_CardID ) where exists ( select 'x' from from V_BackFee B where A.Cust_CardID=B.Cust_CardID )
看看oracle sql reference吧
;
update T_Cust A set A.CUST_NAME=
(select B.CUST_NAME from V_BackFee B
where A.Cust_CardID=B.Cust_CardID
)
where exists
(
select 'x'
from from V_BackFee B
where A.Cust_CardID=B.Cust_CardID
)