Below given Query using for updating a table
it gives error = ORA - 00933 SQL command not properly ended.
if below given query is incorrect , than kindly help to correct it.


update normalised_even t_error
set c_party_interna l_id=(
select distinct service_id,serv ice_name from service_history sh,normalised_e vent_error nee
where sh.service_name =nee.c_party_id
and nee.c_party_int ernal_id...