# SemiJoinSubqueryExpression (/docs/core/reference/api/interfaces/SemiJoinSubqueryExpression)



[@kysoql/core](/docs/core/reference/api) / SemiJoinSubqueryExpression

Typed semi-join or anti-join subquery expression for IN and NOT IN
filters.

## Extended by [#extended-by]

* [`SelectedSemiJoinSubqueryBuilder`](/docs/core/reference/api/interfaces/SelectedSemiJoinSubqueryBuilder)

## Type Parameters [#type-parameters]

| Type Parameter                      |
| ----------------------------------- |
| `DB`                                |
| `OuterTB` *extends* keyof `DB`      |
| `OuterReference` *extends* `string` |

## Methods [#methods]

<a id="api-tooperationnode" />

### toOperationNode() [#tooperationnode]

```ts
toOperationNode(): SemiJoinSubqueryNode;
```

Returns the immutable operation node represented by this builder.

#### Returns [#returns]

[`SemiJoinSubqueryNode`](/docs/core/reference/api/type-aliases/SemiJoinSubqueryNode)

## Properties [#properties]

| Property                                                                                  | Modifier   | Type             | Description                                                                                                 |
| ----------------------------------------------------------------------------------------- | ---------- | ---------------- | ----------------------------------------------------------------------------------------------------------- |
| <a id="api-property-semijoinsubqueryexpressiontype" /> `[semiJoinSubqueryExpressionType]` | `readonly` | `object`         | Type-only brand used by Kysoql to preserve compile-time information; it has no user-facing runtime meaning. |
| `[semiJoinSubqueryExpressionType].db`                                                     | `readonly` | `DB`             | Schema type shared by the outer query and semi-join.                                                        |
| `[semiJoinSubqueryExpressionType].outerTable`                                             | `readonly` | `OuterTB`        | Salesforce object queried by the outer query.                                                               |
| `[semiJoinSubqueryExpressionType].outerReference`                                         | `readonly` | `OuterReference` | Outer field compared with the semi-join selection.                                                          |