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



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

Immutable query AST node for a child relationship subquery.

## Properties [#properties]

| Property                                            | Modifier   | Type                                                                               | Description                                                      |
| --------------------------------------------------- | ---------- | ---------------------------------------------------------------------------------- | ---------------------------------------------------------------- |
| <a id="api-property-kind" /> `kind`                 | `readonly` | `"RelationshipSubqueryNode"`                                                       | Node discriminator used by Kysoql compilers and plugin visitors. |
| <a id="api-property-relationship" /> `relationship` | `readonly` | [`ReferenceNode`](/docs/core/reference/api/type-aliases/ReferenceNode)             | Child relationship referenced by the subquery.                   |
| <a id="api-property-selections" /> `selections?`    | `readonly` | readonly [`SelectionNode`](/docs/core/reference/api/type-aliases/SelectionNode)\[] | Selections emitted by this query or subquery.                    |
| <a id="api-property-where" /> `where?`              | `readonly` | [`WhereNode`](/docs/core/reference/api/type-aliases/WhereNode)                     | Optional `WHERE` expression tree.                                |
| <a id="api-property-orderby" /> `orderBy?`          | `readonly` | [`OrderByNode`](/docs/core/reference/api/type-aliases/OrderByNode)                 | Optional `ORDER BY` clause.                                      |
| <a id="api-property-limit" /> `limit?`              | `readonly` | [`LimitNode`](/docs/core/reference/api/type-aliases/LimitNode)\<`number`>          | Optional `LIMIT` clause.                                         |
| <a id="api-property-offset" /> `offset?`            | `readonly` | [`OffsetNode`](/docs/core/reference/api/type-aliases/OffsetNode)\<`number`>        | Optional `OFFSET` clause.                                        |