Update语句如下：
update parts set parts.suppliername=
(select PARTSCHINESEINF.SUPLLYNAME from PARTSCHINESEINF inner join parts on PARTSCHINESEINF.partsno=parts.partsno)
where parts.partsno in (select parts.partsno from PARTSCHINESEINF inner join parts on PARTSCHINESEINF.partsno=parts.partsno)
第1个回答 2014-05-10
试试：
update parts inner join PARTSCHINESEINF on PARTSCHINESEINF.partsno=parts.partsno
set parts.suppliername=PARTSCHINESEINF.SUPLLYNAME
或者：
update parts set parts.suppliername=dlookup("SUPLLYNAME","PARTSCHINESEINF","partsno=" & partsno)
祝你成功！
update parts inner join PARTSCHINESEINF on PARTSCHINESEINF.partsno=parts.partsno
set parts.suppliername=PARTSCHINESEINF.SUPLLYNAME
或者：
update parts set parts.suppliername=dlookup("SUPLLYNAME","PARTSCHINESEINF","partsno=" & partsno)
祝你成功！
