1、更新tb_card中c_customer字段的值等于tb_customer表中c_no的值
update tb_card
set c_customer=ct.c_no
from tb_customer ct
where tb_card.c_cardno=ct.c_no
1、更新tb_card中c_customer字段的值等于tb_customer表中c_no的值
update tb_card
set c_customer=ct.c_no
from tb_customer ct
where tb_card.c_cardno=ct.c_no
转载于:https://www.cnblogs.com/Zeros/p/5591999.html