javaliujie 发表于 2013-1-14 23:25:02

Informix联表更新

update table_a set apname=(select max(name) from person
where id=table_a.apid)
where apid in(select id from person)
and (apname='' or apname is null);
页: [1]
查看完整版本: Informix联表更新