j & # 39; uses
Informix Dynamic Server version 12.10.FC9W1X2.
I need to update a table with fields from another table. I'm trying to use the
statement, but I'm not able to use a
Where the clause to filter the information of the table being updated because this causes a syntax error. I've also tried to add
When corresponds and it does not work.
Is there a way to do that?
This is my statement so far,
MERGE IN table1 as t1 USE table2 as t2 ON t1.some_no = t2.some When corresponds THEN UPDATE SET t1.some_other_no = t2.some_other_no, is_processed = "Y", resolution = "AAA & # 39;