利用表b中的某列数据去更新表a中的某列数据,a与b中cc字段为关联字段
update a set a.xxx=(select b.xxx from b where a.cc=b.cc)
例如:
update T_SequencEntry set T_SequencEntry.FSeqID=(select T_Sequenc.FID from T_Sequenc where T_SequencEntry.FSeqID=T_Sequenc.FID)
利用表b中的某列数据去更新表a中的某列数据,a与b中cc字段为关联字段
update a set a.xxx=(select b.xxx from b where a.cc=b.cc)
例如:
update T_SequencEntry set T_SequencEntry.FSeqID=(select T_Sequenc.FID from T_Sequenc where T_SequencEntry.FSeqID=T_Sequenc.FID)