update BCS_RECVLIST_NEW a
SET checkstatus='1'
where exists(select 1 from BCS_TRANSFER_DETIAL_NEW b where a.BOSSSerialNumber=b.BossSerialNumber and a.RECVFEE=b.TransferAmount);
SET checkstatus='1'
where exists(select 1 from BCS_TRANSFER_DETIAL_NEW b where a.BOSSSerialNumber=b.BossSerialNumber and a.RECVFEE=b.TransferAmount);
RECVFEE in (select TransferAmount from BCS_TRANSFER_DETIAL_NEW where BOSSSerialNumber=BCS_RECVLIST_NEW.BOSSSerialNumber)orupdate BCS_RECVLIST_NEW set checkstatus='1' where
RECVFEE=(select distinct TransferAmount from BCS_TRANSFER_DETIAL_NEW where BOSSSerialNumber=BCS_RECVLIST_NEW.BOSSSerialNumber)or
update BCS_RECVLIST_NEW set checkstatus='1' where
exists (select * from BCS_TRANSFER_DETIAL_NEW where BOSSSerialNumber=BCS_RECVLIST_NEW.BOSSSerialNumber and TransferAmount=BCS_RECVLIST_NEW.RECVFEE)
RECVFEE in (select TransferAmount from BCS_TRANSFER_DETIAL_NEW where BOSSSerialNumber=BCS_RECVLIST_NEW.BOSSSerialNumber)
TableA 表的字段: Num Number(5),Name VarChar(20)TableB 表的字段: Num Number(5),Name VarChar(20),IsOld Number(1) Default 0用 SQL 2000 的描述方法是:
Update B
set B.Name = A.Name,B.IsOld = 0
from TableA A,TableB B
where A.Num = B.Num and B.IsOld = 1;
在 ORACLE 中怎实现?