Below is a generalized format for the merge statement.
The merge statement works using two tables, the source Table and target Table.
In this article, we’ll explore how to use the MERGE statement.
If your aim is to completely synchronize the target Table data with the source, then you’ll use this match condition to DELETE rows.
If you’re having trouble understanding how this works, consider the merge condition is like a join condition.
ROWS in the green section represent rows that match the merge condition, rows in the blue section are those rows found in the Source Table, but not in the target.
The rows in the orange section are those rows found only in the target.
Here is the DELETE statement we can use: MERGE esql Product Target T USING esql Product Source S ON (S.