你更新表 custinfo,却在 where 字句中参考另一个表的名称,这是不允许的。
如果你采用下面这种方式,将不会出问题:
update custinfo set custinfo.superid=test.superid,custinfo.corpid=test.corpid,
custinfo.fenju=test.fenju
from custinfo inner join test
on custinfo.corpname=test.corpname
如果你采用下面这种方式,将不会出问题:
update custinfo set custinfo.superid=test.superid,custinfo.corpid=test.corpid,
custinfo.fenju=test.fenju
from custinfo inner join test
on custinfo.corpname=test.corpname
update custinfo
set custinfo.superid=test.superid,custifo.corpid=test.corpid,
custinfo.fenju=test.fenju
from custinfo,test
where custinfo.corpname=test.corpname