updating using SubQuery Problen

[d4dyf786]

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_event_error
set c_party_internal_id=(
select distinct service_id,service_name from service_history sh,normalised_event_error nee
where sh.service_name=nee.c_party_id
and nee.c_party_internal_id is null
and trunc(nee.charge_start_date) > sysdate -35
and nee.error_message_id=2563
and SERVICE_STATUS_CODE=3
) d
where d.service_name=c_party_id
and SERVICE_STATUS_CODE=3
and sysdate between effective_start_date and effective_end_date

[amitpatel66]

Your sub query select 2 columns and it is NOT POSSIBLE to update one column with 2 values.

Your UPDATE query is incorrect and you need to change to sleect only one column in the subquery that you want to update with. Make these changes and post back in case of any issues

[Pilgrim333]

Furthermore, you give an alias to the sub query you use to update the values and you use that in your where clause. I don't think that will work either.

Pilgrim.