一个update 语句,请教各位
update BCS_RECVLIST_NEW
SET checkstatus='1'
where
BOSSSerialNumber in (
select BossSerialNumber
from BCS_TRANSFER_DETIAL_NEW)
and RECVFEE=(select distinct BCS_TRANSFER_DETIAL_NEW.TransferAmount
from BCS_RECVLIST_NEW,BCS_TRANSFER_DETIAL_NEW
where BCS_RECVLIST_NEW.BOSSSerialNumber= BCS_TRANSFER_DETIAL_NEW.BossSerialNumber);
我想把表BCS_RECVLIST_NEW中满足where中两个条件的记录的checkstatus字段设为‘1’;
具体条件为:
1 BOSSSerialNumber 在 BCS_TRANSFER_DETIAL_NEW 中存在
2 RECVFEE 等于表 BCS_TRANSFER_DETIAL_NEW 中与它的BOSSSerialNumber对应的那条记录的TransferAmount
请教各位大侠该怎么写?