Differences

This shows you the differences between two versions of the page.

--- valentina:vcomponents:vsql:reference:merge [2019/07/12 05:41]
lynn
+++ valentina:vcomponents:vsql:reference:merge [2020/12/16 20:52] (current)
@@ Line 45: / Line 45: @@
 Valentina joins the tables internally and then, iterates the join result firing appropriate actions for each join-result row.
-There are three(3) possible "merge actions" (at least for now):
+There are three(3) "merge actions" currently supported by MERGE:
   * **WHEN MATCHED**. Fired when there is a record in target table for current source table's record. It could be "UPDATE" or "DELETE" statements only;
   * **WHEN NOT MATCHED [BY TARGET]**. Fired when there is no record in target table for current source table's record. It could be the "INSERT" statement only;