| Value | Meaning |
|---|---|
| join | Normal join operation. Equivalent to INNER JOIN |
| crossJoin | Cartesian product of the tables |
| leftJoin | Given: T1 LEFT JOIN T2 ON .. First, an inner join is performed. Then, for each row in T1 that does not satisfy the join condition with any row in T2, a joined row is added with null values in columns of T2. |
| rightJoin | Given: T1 RIGHT JOIN T2 ON .. First, an inner join is performed. Then, for each row in T2 that does not satisfy the join condition with any row in T1, a joined row is added with null values in columns of T1. |
| fullJoin | Given: T1 FULL JOIN T2 ON .. First, an inner join is performed. Then, for each row in T2 that does not satisfy the join condition with any row in T1, a joined row is added with null values in columns of T1. Also, for each row in T1 that does not satisfy the join condition with any row in T2, a joined row is added with null values in columns of T2. |
Representation of a join type.