Merge – Add further table rows

Merge, Target table, Source table [, Filter instruction]

Using the Merge function, further rows from the data table "Source table" are added to the data table "Target table"; optionally, the new rows can also be filtered.

Only those rows are added that are not yet contained in the target data table.

Any data tables can be merged as long as they have the same column definitions: The same number and sequence of column names (case-insensitive).

An alternative function name is: Join

Example

from 001 xcf create table 06

A new table "Product" is created from the table "Products" with all Products of the C category. Ultimately, all Products with the price from 75.99 to 135.99 are added from the "Products" table to the "Product" table.

The target table "Product" now contains all products from table "Products":

  • of the C category

  • or with a price from 75.99 to 135.99.