update cs_pb_base set (TOTAL_COUNT, LAST_DATE, BEGIN_DATE)
=(select TOTAL_COUNT+1, b.PB_DATE, SYSDATE
from cs_pb_trans b where b.USER_ID=cs_pb_base.USER_ID) where b.USER_ID=cs_pb_base.USER_ID;
=(select TOTAL_COUNT+1, b.PB_DATE, SYSDATE
from cs_pb_trans b where b.USER_ID=cs_pb_base.USER_ID) where b.USER_ID=cs_pb_base.USER_ID;
2 =(select TOTAL_COUNT+1, b.PB_DATE, SYSDATE
3 from cs_pb_trans b where b.USER_ID=cs_pb_base.USER_ID)
4 where exists (select 1 from cs_pb_trans b where b.USER_ID=cs_pb_base.USER_ID);已更新 1 行。SQL> select * from CS_PB_BASE;USER_ID USER_NAME TOTAL_COUNT LAST_DATE BEGIN_DATE
-------------------------------- -------------------------------- ----------- ---------- ----------
WO
--
2228 用户一 0 01-11月-03 01-11月-03
02079 用户二 1 01-11月-03 29-10月-03
0
SQL>