ORACLE多表关联UPDATE

CREATE TABLE T1 (FMID VARCHAR2(20),FTYPE VARCHAR2(20),FMONEY NUMBER);
INSERT INTO T1 VALUES ('M002265',  '一星币',100);
INSERT INTO T1 VALUES ('M00000331','一星币',200);
INSERT INTO T1 VALUES ('M00002363','一星币',300);
INSERT INTO T1 VALUES ('M001561',  '一星币',400);
INSERT INTO T1 VALUES ('M002265',  '原奖金币',110);
INSERT INTO T1 VALUES ('M00000331','原奖金币',210);
INSERT INTO T1 VALUES ('M00002363','原奖金币',310);
INSERT INTO T1 VALUES ('M001561',  '原奖金币',410);
INSERT INTO T1 VALUES ('M002265',  '原结算',110);
INSERT INTO T1 VALUES ('M00000331','原结算',210);
INSERT INTO T1 VALUES ('M00002363','原结算',310);
INSERT INTO T1 VALUES ('M001561',  '原结算',410);
INSERT INTO T1 VALUES ('M0022651', '原结算',1110);
INSERT INTO T1 VALUES ('M00000332','原结算',1210);
INSERT INTO T1 VALUES ('M00002364','原结算',1310);
INSERT INTO T1 VALUES ('M001562',  '原结算',1410);
INSERT INTO T1 VALUES ('M0022651', '一星币',2110);
INSERT INTO T1 VALUES ('M00000332','一星币',2210);
INSERT INTO T1 VALUES ('M00002364','一星币',2310);
INSERT INTO T1 VALUES ('M001562',  '一星币',2410);
INSERT INTO T1 VALUES ('M0022651', '原未发',2110);
INSERT INTO T1 VALUES ('M00000332','原未发',2210);
INSERT INTO T1 VALUES ('M00002364','原未发',2310);
INSERT INTO T1 VALUES ('M001562',  '原未发',2410);
INSERT INTO T1 VALUES ('M0