多表关联更新，UPDATE FROM用法

UPDATE A set A.ImageID_list=F.AListImgID
FROM ProgramRelate A, #temp_rlt F
WHERE A.PID=F.PAutoID