UPDATE kingdee_pro_stock set
kingdee_pro_stock.org_name=ERP_BASIC_BILLNO_PREFIX.org_name,
kingdee_pro_stock.page_no=ERP_BASIC_BILLNO_PREFIX.page_no,
kingdee_pro_stock.page_name=ERP_BASIC_BILLNO_PREFIX.page_name,
kingdee_pro_stock.djlb_no = ERP_BASIC_BILLNO_PREFIX.djlb_no,
kingdee_pro_stock.djlb_name = ERP_BASIC_BILLNO_PREFIX.djlb_name,
kingdee_pro_stock.bz = ERP_BASIC_BILLNO_PREFIX.remark,
kingdee_pro_stock.djlb_code=ERP_BASIC_BILLNO_PREFIX.djlb_code
from ERP_BASIC_BILLNO_PREFIX
where kingdee_pro_stock.prefix_id=ERP_BASIC_BILLNO_PREFIX.id
============================
sql server
============================
UPDATE 表1
SET 表1 .字段= 表2.字段
FROM 表2
WHERE 表2.关链字段=表1.关链字段;
============================
mysql
============================
UPDATE 表1,表2
SET 表1 .字段= 表2.字段
WHERE 表2.关链字段=表1.关链字段;