Ways to join a related entity to a query

In SQL, you can join a table to a query in these ways:

Inner join

Excludes rows/instances on the left that have no matches on the right.

Outer left join

Includes rows/instances from the left that have no matches on the right.

Outer right join

Include rows/instances from the right that have no matches on the left.

Full outer join

Include rows/instances that have no matches, regardless of side

The query builder APIs support inner joins and outer left joins only. Outer right joins and outer full joins are not supported.