SQL 8

[gagaxiaoyuer]

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.

[liangCK]

没有From指定POWER_METER表

[wzy_love_sly]

● █〓██▄▄▄▄▄ ●●●●●●
▄▅██████▅▄▃▂
██████████████
◥⊙▲⊙▲⊙▲⊙▲⊙▲⊙▲◤.

[wzy_love_sly]

UPDATE   PARTNER_ADDRESS   SET   FADDR1=REPLACE(FADDR1,'栋','幢')  
from POWER_METER,PARTNER_ADDRESS
WHERE
POWER_METER.FPARTNER_ID=PARTNER_ADDRESS.FPARTNER_ID
AND   FCONCENTRATOR_NO='2000228266' 

[liangCK]

UPDATE a SET FADDR1=REPLACE(FADDR1,'栋','幢')   
FROM PARTNER_ADDRESS a ,POWER_METER b
WHERE 
b.FPARTNER_ID=a.FPARTNER_ID 
AND FCONCENTRATOR_NO='2000228266' 

上面有些列不知道你是PARTNER_ADDRESS表还是POWER_METER表的.所以你自己随后指定.