Oracle-更新字段-一张表的字段更新另一张的表的字段
摘要:
MERGE INTO A_MERGE A USING (select B.AID,B.NAME,B.YEAR from B_MERGE B) C ON (A.id=C.AID) WHEN MATCHED THEN UPDATE SET A.YEAR=C.YEAR WHEN NOT MATCHED T 阅读全文
posted @ 2015-05-28 10:20 梦相随1006 阅读(2618) 评论(0) 推荐(1) 编辑