UPDATE Table_A T
SET T.LatestTM=S.TM， T.LatestData=S.Data
FROM
(select A.ID, B.TM, A.DATA
from TABLE_B A,
JOIN (select B.ID,MAX(B.TM) from TABLE_B B group by B.ID) C
ON A.ID = C.ID
) S
where Table_A.ID = S.ID
不是很明白你的说法,是要这个么
SELECT * INTO TABLE_B FROM TABLE_A
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ号：24596024