Databases Reference
In-Depth Information
The CONCATENATE statement
The
CONCATENATE
statement is also a prefix to the
LOAD
statement, but instead of
matching and merging rows between tables, this statement appends the rows of one
table to another table.
Let us again consider the same two tables from the previous example:
We use the following code to concatenate the two tables:
Table1:
LOAD * INLINE
[
A, B, C
1, 1, 1
2, 2, 2
3, 3, 3
];
CONCATENATE (Table1)
LOAD * INLINE
[
B, C, D
2, 2, 2
3, 3, 3
5, 5, 5
];
The result is the following table: