update B
set B.B05=A02
from B join A on B.C01=A.C01

本文转载:CSDN博客