benjamenus
Programmer
I'm sure this is really simply. I want to perform the following update but this will not work as I don't mention the table tempmjb1. However, if I type 'update policy, tempmjb1' I get a 'missing SET keyword' error. What's the Oracle solution please?
update
policy
set
policy.cov_cod = tempmjb1.new_cod,
policy.des_txt = tempmjb1.new_des,
policy.chg_by = tempmjb1.chg_by,
policy.chg_dte = tempmjb1.chg_dte
where
policy.acc_num = tempmjb1.acc_num
and policy.cov_maj = tempmjb1.cov_maj
and policy.cov_cod = tempmjb1.cov_cod
and policy.loc_cod = tempmjb1.loc_cod;
update
policy
set
policy.cov_cod = tempmjb1.new_cod,
policy.des_txt = tempmjb1.new_des,
policy.chg_by = tempmjb1.chg_by,
policy.chg_dte = tempmjb1.chg_dte
where
policy.acc_num = tempmjb1.acc_num
and policy.cov_maj = tempmjb1.cov_maj
and policy.cov_cod = tempmjb1.cov_cod
and policy.loc_cod = tempmjb1.loc_cod;