求助.................

我想把b表的时间 更新为 a 表的 时间 怎么寫啊.....各位大虾帮帮忙看看..................多谢了..select a.subs_relation_id,a.mobileno,a.start_date,a.end_date,b.subs_relation_id,b.sub_attach_info,b.addeffecttime,b.addendtime from SP_SUBSCRIBER_RELATION a inner join SP_SUBSCRIBER_ATTRINFO b on a.subs_relation_id=b.subs_relation_id