Joins in SELECT statements

A join is a relational operation in a SELECT statement that retrieves data from two or more tables, based on matching column values. The data in the tables is linked into a single result.

The following table lists the join operators:

Table 1. Join operator descriptions
Join Operator Definition
Inner join Each row of the first table is combined with each row of the second table, keeping only the rows where the join condition is true. The results table might be missing rows from either or both of the joined tables. Outer joins include the inner join and preserve these missing rows. An inner join is the default operator for a new join in the SQL builder.
Left outer join Includes rows from the first table that were missing from the inner join.
Right outer join Includes rows from the second table that were missing from the inner join.
Full outer join Includes rows from both tables that were missing from the inner join.
Related tasks
Creating joins in the SQL builder

Feedback