Unanswered: Using inline views in an update statement
Is it possible to use an inline view in an update statement?
I am trying to run the following SQL in Sybase ASE 12.5
set a.addr_open_acct_cnt = (a.addr_open_acct_cnt + b.addr_open_acct_cnt)
from cims_ds_address_key_map a,
(select cims_new_hh_addr_id as cims_address_id,
count(*) as addr_open_acct_cnt
where addr_new_existing_cd = 'E'
group by cims_new_hh_addr_id) as b
where a.cims_address_id = b.cims_address_id
I am getting an error saying "incorrect syntax near the keyword 'select'".