如果这3个表都是同一个数据库的,直接使用sql的update更新即可。
关联条件是无法使用case when的,上面sql改为下面sql
sel
ect 清单条码编码, 发货日期, {ddpsb}.zzh, {ddqdb}.zzh, zzh_xx, zzh_yy from {ddpsb} right Join {ddqdb} on {ddpsb}.zzh = {ddqdb}.zzh and {ddpsb}.zzh_xx is not null and {ddpsb}.zzh_xx = right({ddqdb}.zzh_yy,2) where {ddpsb}.发货日期 Is Not null
union
select 清单条码编码, 发货日期, {ddpsb}.zzh, {ddqdb}.zzh, zzh_xx, zzh_yy from {ddpsb} right Join {ddqdb} on {ddpsb}.zzh = {ddqdb}.zzh and {ddpsb}.zzh_xx is null where {ddpsb}.发货日期 Is Not null