在informix中如何实现类似update A set (a1,a2)=(select b1,b2fromB where A_ID=B_ID)?

[junehzhw]

在informix中如何实现类似update A set (a1,a2)=(select b1,b2fromB where A_ID=B_ID)？
也就是当A表和B表满足一定条件时将A表的两个字段更新成B表的两个字段，强调在INFORMIX中的实现，谢谢

[java_new_comer]

update A set (a1,a2)=(select b1,b2 from B where A_ID=B_ID) where A_ID=B_ID

[feiger725]

update temp_old
set (a,b)=(select a,b from temp_new
where chnl_code=temp_old.chnl_code)
where 1=1 测试结果： 201: A syntax error has occurred.
我想只能一个字段一个字段来了

[dreamloversun]

update语句本来就不能这样写，只能一个一个的来
update A set a1 = (select B.b1 from B where A_ID=B_ID),
a2 = (select B.b2 from B where A_ID=B_ID)
where A_ID=B_ID;

[lbtx69]

update f_serv_temp set (area_code,serv_num,prod_type_id,serv_name)=((
select b.area_code,b.serv_num,b.prod_type_id,b.serv_name from serv_his_temp2 b where f_serv_temp.serv_id=b.serv_id) ) where serv_id='205110';

要加2个括号。