UPDATE Table1. SET Column1 = (. SELECT Column2, SUM(Amount) FROM Table2. GROUP BY Column2. )X INNER JOIN Table1. ON x.Column2 = Column1.
確定! 回上一頁