tableName1:
kcdm 代码
kcmc 名称
tableName2
kcdm 代码
kcmc 名称
需求:根据tableName1中kcdm字段查询tableName2表中tableName1.kcdm = tableName2.kcdm 的 kcmc填充到tableName1中
update tableName1 set kcmc = (SELECT a.kcmc from tableName2 a where a.kcdm = TP_GLOBAL_JNKC.kcdm);
参考:https://blog.csdn.net/heqinghua217/article/details/52998090