Skip to main content

LeftOuterJoin

A Join subclass that hard-codes JoinType.LEFT_OUTER, rendering left outer join. See the Joins guide for a full walkthrough.

Constructor

LeftOuterJoin(table: string | TableName | Select | Raw): LeftOuterJoin
new LeftOuterJoin(table: string | TableName | Select | Raw): LeftOuterJoin

Dual-callable. Equivalent to Join(JoinType.LEFT_OUTER, table).

import { LeftOuterJoin, Select } from '@sqb/builder';

Select().from('t1').join(LeftOuterJoin('t2'));
// ... left outer join t2

Properties

Inherits every property from Join (_type, _joinType, _table, _conditions); _joinType is always JoinType.LEFT_OUTER.

Methods

Inherits .on() from Join; LeftOuterJoin adds no methods of its own.

See also