UPDATE PARTNER_ADDRESS SET FADDR1=REPLACE(FADDR1,'栋','幢')
WHERE
POWER_METER.FPARTNER_ID=PARTNER_ADDRESS.FPARTNER_ID
AND FCONCENTRATOR_NO='2000228266'
提示这句话 什么意思啊 The column prefix 'POWER_METER' does not match with a table name or alias name used in the query.
from POWER_METER,PARTNER_ADDRESS
WHERE
POWER_METER.FPARTNER_ID=PARTNER_ADDRESS.FPARTNER_ID
AND FCONCENTRATOR_NO='2000228266'
FROM PARTNER_ADDRESS a ,POWER_METER b
WHERE
b.FPARTNER_ID=a.FPARTNER_ID
AND FCONCENTRATOR_NO='2000228266'
上面有些列不知道你是PARTNER_ADDRESS表还是POWER_METER表的.所以你自己随后指定.