Code update tbbusinesscard set ch_Memo1=(select aa.ch_memo1 from aa,tbbusinesscard where (aa.ch_name=tbbusinesscard.ch_name))
--sql 将A表中的字段复制到B表中
-- 如: tbbusinesscard为表B aa为表a update tbbusinesscard set ch_Memo1=(select aa.ch_memo1 from aa where (aa.ch_name=tbbusinesscard.ch_name))