Trigger : AFTER INSERT UPDATE on other table

[MICHAEL FAURE]

Hi,

I have 2 tables :


1) e_ with :

id_e (INT AI PRIMARY KEY)
c1 (VARCHAR)
c2 (INT)


2) e_h with :

id_e_h (INT AI PRIMARY KEY)
d1 (VARCHAR)
d2 (INT)

------------------------------------------------------------------------------------------

Using a trigger on e_h AFTER INSERT I'd like to UPDATE c2 WHERE c1 = d1

But I get the ERROR subquery returns more than 1 row

------------------------------------------------------------------------------------------

This is the trigger :

UPDATE e_ SET c2 =
(SELECT d2 FROM e_h WHERE c1 = d1)

------------------------------------------------------------------------------------------

May someone help me on how to fix that issue ?