如下例,通过表noticesx中的version字段更新表gysxzl里的version字段 update a set a.version=b.version from gysxzl as a,noticesx as b where a.tid=b.tenoticeid and b.sxid=37