The following table lists the join operators:
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. |