UPDATE A,B SET A.YE=B.YE WHERE A.XMDH=B.XMDH 
<END>    
Çë ¿´ Òý ×Ô Ms SQL 7µÄ ¡¶ Transact-SQL HELP¡· Ö® "UPDATE (T-SQL)"Ä¿ Â¼ : 
    ... 
    UPDATE titles 
    SET ytd_sales = (SELECT SUM(qty) 
     FROM sales 
     WHERE sales.title_id = titles.title_id 
     AND sales.ord_date IN (SELECT MAX(ord_date) FROM sales)) 
    FROM titles, sales 
    ... 
     
    Õý È· µÄ ×÷ ·¨ (ÔÚ Ms SQL 7 Transact-SQLÊµ ÏÖ ): 
     UPDATE A 
     SET YE=B.YE 
     FROM A INNER JOIN B ON A.XMDH=B.XMDH 
    ×¢ Òâ : 
     Access ²» Ö§ ³Ö UPDATE...SET... µÄ FROM ×Ó ¾ä ! 
<END>    
°´ ÕÕ Èç ÏÂ µÄ SQLÓï ¾ä ¼´ ¿É : 
    UPDATE A INNER JOIN B ON A.XMBH = B.XMBH SET A.YE = [B].[YE] 
<END>