I am getting following error.
An action of type 'DELETE' is not allowed in the 'WHEN NOT MATCHED' clause of a
MERGE statement.
my query is like below.
MERGE CUS2 AS TARGET
USING CUS1 AS SOURCE
ON (TARGET.CUSNUMBER = SOURCE.CUSNUMBER)
WHEN MATCHED
THEN UPDATE
SET
CUSNUMBER = SOURCE.CUSNUMBER
WHEN NOT MATCHED BY TARGET THEN
DELETE
WHEN NOT MATCHED
THEN INSERT(CUSNUMBER) VALUES(SOURCE.CUSNUMBER);