Skip to main content

FullOuterJoin

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

Constructor

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

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

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

Select().from('t1').join(FullOuterJoin('t2'));
// ... full outer join t2

Properties

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

Methods

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

See also