sea026: 大致这样吧... [阅读: 287] 2005-04-19 07:36:03 update tab1 set [Name]=B.Name from tab1 A left join tab2 B on A.code=B.code [SIZE=26]用有道,不用道理。[/SIZE]