此乃sqlserver连表更新,不过结果不对
update doctor set doctor.zhuanqu =doctor1.zhuanqu FROM
doctor
INNER JOIN
doctor1
on doctor1.wdid=doctor.wdid
此乃sqlserver连表更新,不过结果不对
update doctor set doctor.zhuanqu =doctor1.zhuanqu FROM
doctor
INNER JOIN
doctor1
on doctor1.wdid=doctor.wdid