Join Operations

This section contains the reference documentation for the Splice Machine SQL Join Operations, in the following topics:

Topic Description
About Join Operations Overview of joins.
CROSS JOIN Produces the Cartesian product of two tables: it produces rows that combine each row from the first table with each row from the second table.
INNER JOIN Selects all rows from both tables as long as there is a match between the columns in both tables.
LEFT OUTER JOIN

Returns all rows from the left table (table1), with the matching rows in the right table (table2). The result is NULL in the right side when there is no match.

NATURAL JOIN Creates an implicit join clause for you based on the common columns (those with the same name in both tables) in the two tables being joined.
RIGHT OUTER JOIN Returns all rows from the right table (table2), with the matching rows in the left table (table1). The result is NULL in the left side when there is no match.



For access to the source code for the Community Edition of Splice Machine, visit our open source GitHub repository.