Hi all,
My query works well with SELECT command but, when I try to use the UPDATE command, I have the error listed above.
There is my query :
update PER_EMAIL_ADDRESSES
set EMAIL_ADDRESS='fausseAdresse@yopmail.com'
where EMAIL_ADDRESS_ID=(select CAND_EMAIL_ID
from IRC_CANDIDATES
where CANDIDATE_NUMBER=1123028
)
Could you explain me what's wrong here ?