Hi,
Getting above error when try and update table to value note the tables updateing from do not have null value.
Finding haveing to put extra condition in the outer query to run this.
Oracle 11.2.0.3
update cas_agent_net_sales b
set b.net_issue_ean = (
-- Purpose to reset the ean to one should eb as above
select nvl(p.new_bris_ean_to_use,p.net_issue_ean)
from por_fix_cans_temp_280514_york p
where p.net_agent_account_number = b.net_agent_account_number
and p.net_issue_ean = b.net_issue_ean
and p.net_issue_year = b.net_issue_year)
where b.net_title_code = 4181
Why is this nrecessary?
Thanks