Databases Reference
In-Depth Information
Let us consider the same two tables from the
JOIN
example:
If we apply a
LEFT KEEP
statement to these two tables, like shown in the
following code:
Table1:
LOAD * INLINE
[
A, B, C
1, 1, 1
2, 2, 2
3, 3, 3
];
Table2:
LEFT KEEP (Table1)
LOAD * INLINE
[
B, C, D
2, 2, 2
3, 3, 3
5, 5, 5
];
The result we get is the following two tables. As you can see, the last row from
the original
Table2
has been filtered out as it does not correspond to any of the
rows in
Table1
: