Join

Outputs the natural join of two relations (tables) where attributes (columns) are matched by name. Matching attributes must be of the same type.

There is no outer join, tuples (rows) that do not match are dropped from the output. Optionally the output may be restricted to just the attributes of the left hand relation (semijoin), or the inverse of that (antijoin).

Options

Join

Output tuples contain all attributes from both inputs.

Semijoin

Output tuples from the left relation that match a tuple from the right relation.

Antijoin

Output tuples from the left relation that DO NOT match a tuple from the right relation.

Views

This node has no views

Workflows

• No workflows found

Links

• No links available

Developers