# merge

open fun merge(dest: Table, source: Table, transaction: Transaction, clauses: List<MergeStatement.Clause>, on: Op<Boolean>?): String

Generates the SQL MERGE command which synchronizes two datasets by inserting new rows, or updating/deleting existing ones in the target table based on data from another table.

#### Parameters

dest

The table that will be modified.

source

The table providing the data for modification.

transaction

The transaction in which the operation will be executed.

clauses

A list of `MergeStatement.When` instances describing the `when` clauses of the SQL command.

on

The condition that determines whether to apply insertions or updates/deletions.