一个sql的小问题求助

gamiwqu

pps_user_info.usertype,对于每个用户绝对是单一的值.其对应的在pps_rent_fee 中的rentindex也是没有重复值的.

qqq000999

select 1,2,3 from B bb
where not exists (select * from B where 3=bb.3 and 2>bb.2 )
into temp ss;

update A set
a= ( select 1 from ss where  3= A.c )
where 1=1;

update A set
b= ( select 2 from ss where  3= A.c )
where 1=1;

xjfirst

一个笨一点的办法：
unload to upd_tmp.sql delimier select "update A set a = " || 1 || ", b = " || 2 || " where c = " || 3 from A, B where A.c = B.3;
然后再运行upd_tmp.sql
不过这完全是个手工的过程。