表一：conv_line
conv_line_oid error_msg
1001 client %s1 not facility %s2
1002 client %s1 not facility %s2
表二
facility_group
facility_group_oid client facility conv_line_oid
2001 clientA facilityA 1001
2002 clientB facilityB 1002
要把
conv_line_oid error_msg
1001 client %s1 not facility %s2
1002 client %s1 not facility %s2
更新为
conv_line_oid error_msg
1001 client clientA not facility facilityA
1002 client clientB not facility facilityB
有何实现办法吗？
------解决方案--------------------
SELECT A.CONV_LINE_OID,
REPLACE(REPLACE(A.ERROR_MSG, '%s1', B.CLIENT), '%s2', B.fACILITY)
FROM CONV_LINE A, FACILITY_GROUP B
WHERE A.CONV_LINE_OID = B.CONV_LINE_OID;
------解决方案--------------------
- SQL code
gocreate table conv_line(conv_line_oid varchar(4),error_msg varchar(50) )goinsert conv_lineselect '1001','client %s1 not facility %s2' union allselect '1002','client %s1 not facility %s2'gocreate table facility_group(facility_group_oid varchar(4),client varchar(10),facility varchar(10),conv_line_oid varchar(4))goinsert facility_groupselect '2001','clientA','facilityA','1001' union allselect '2002','clientB','facilityB','1002'update conv_lineset error_msg=replace(REPLACE(error_msg,'%s1',client),'%s2',facility)from facility_group a where a.conv_line_oid=conv_line.conv_line_oidselect * from conv_line/*conv_line_oid error_msg1001 client clientA not facility facilityA1002 client clientB not facility facilityB*/MSSQL语法，楼主修改数据类型即可
------解决方案--------------------
楼主的不仅仅是replace问题，还有update from的问题，
在oracle中没有update from，这个语法是sql server的，
虽然可以通过子查询的方式来实现update from的功能：
但是如果把replace也加进去，好像就有问题了，也就是说replace中不能写select语句吧
------解决方案--------------------
update + select ，这倒不是什么问题。
建议再看一下这两张表，是否存在 一对多的关系，否则，需要微调一下SQL。