MySQL 中实现将 一张表table1 中的字段name 等于table2 中的字段 name 通过相同字段no相连,实现如下:
update table1 a1,table2 a2 set a1.name=a2.name where a1.no=a2.no;
(前提是两张表至少有两个字段相关联的,仅供参考MySQL,Oracle则有不同)
Oracle-------------更新暂估应付单的tally_agr表参照tally表
update arap_tally_agr
set (arap_tally_agr.money_cr,
arap_tally_agr.money_de,
arap_tally_agr.local_money_cr) =
(select arap_tally.money_cr,
arap_tally.money_de ,
arap_tally.local_money_cr
from arap_tally
where arap_tally.pk_item = arap_tally_agr.pk_item)
where exists (select 1
from arap_tally
where arap_tally.pk_item = arap_tally_agr.pk_item
and arap_tally.billclass='zf');