李颖: 可以 [阅读: 433] 2004-07-13 05:56:43 UPDATE TAB1 SET NAME = TAB2.ADDRESS, AGE = TAB2.WEIGHT FROM TAB2 WHERE TAB1.ID = TAB2.ID 好像只有M$ SQL Server支持 DISSENT IS THE HIGHEST FORM OF PATRIOTISM ! --Thomas Jefferson