Hi All
as below that merge statement to execute that show the Error
Can you provides the solution and how to overcome it.....
MERGE INTO FRAA T using (
SELECT
LA.MEID MEID,
LA.MID MID,
LA.DEID DEID,
LI.DISID DISID,
LA.ST ST
FROM G_MAN LA
INNER JOIN L_DISP LI
ON(LA.DEID=LI.DEID))S
on(s.DEID<>t.DEID
AND S.MID=T.MID)
WHEN MATCHED THEN UPDATE SET
T.DEID=S.DEID,
T.DISID=S.DISID;