select * from lm_loan ln where ln.bch_cde in (‘1’,‘2’,’3‘) and ln.loan_deva_ind='Y' and ln.loan_sts='ACTV' update lm_ln_info li set li.Ln_Cost_Prod =Ln_Cost_Prod+(lm_loan.loan_os_prcp-TOT_PROV_AMT) where li.loan_no = 上面查出
这个语句本来应该是查询第一条sql的之后得出的多条 lmloan 记录,之后遍历lmloan 记录来执行第二条更新语句,但是现在需要改成用一条连接更新语句 对表进行更新。希望大家帮忙!
这个语句本来应该是查询第一条sql的之后得出的多条 lmloan 记录,之后遍历lmloan 记录来执行第二条更新语句,但是现在需要改成用一条连接更新语句 对表进行更新。希望大家帮忙!
2.先动手自已做两个表,试着在两表之间使用update语句。参考一下:http://blog.sina.com.cn/s/blog_511041a10100ah2b.html
3.应给出lm_loan,lm_ln_info两表的详细字段,以作参考之用。
update lm_ln_info li set li.Ln_Cost_Prod =Ln_Cost_Prod+(lm_loan.loan_os_prcp-TOT_PROV_AMT) where exists (Select loan_no from lm_loan ln where ln.bch_cde in (‘1’,‘2’,’3‘) and ln.loan_deva_ind='Y' and ln.loan_sts='ACTV' and li.loan_no=ln.loan_no)
(select li.ln_cost_prod+ln.loan_os_prcp-ln.tot_prov_amt from lm_loan ln
where ln.bch_cde in('1','2','3') and ln.loan_deva_ind='Y' and ln.loan_sts='ACTV'
and li.loan_no=ln.loan_no)
where exists
(select 1 from lm_loan where bch_cde in('1','2','3') and loan_deva_ind='Y'
and loan_sts='ACTV' and li.loan_no=loan_no)