update AC01 A

set A.AAC003 = REGEXP_REPLACE(A.AAC003, '( ){1,}', '')

WHERE A.AAC002 IN (SELECT AAC002 FROM ac01_temp_);