> ## Documentation Index
> Fetch the complete documentation index at: https://docs.kinetica.com/llms.txt
> Use this file to discover all available pages before exploring further.

# CreateJoinTableRequest

> CreateJoinTableRequest — Kinetica TypeScript API

interface CreateJoinTableRequest \{\
&#x20;[column\_names](#column_names): string\[];\
&#x20;[expressions](#expressions)?: string\[];\
&#x20;[join\_table\_name](#join_table_name): string;\
&#x20;[options](#options)?: Record\<string, string>;\
&#x20;[table\_names](#table_names): string\[];\
}

<ul>
  <li>Defined in [src/types.ts:1705](https://github.com/kineticadb/kinetica-api-typescript/blob/master/src/types.ts#L1705)</li>
</ul>

##### Index

### Properties

[column\_names](#column_names) [expressions?](#expressions) [join\_table\_name](#join_table_name) [options?](#options) [table\_names](#table_names)&#x20;

## Properties

### column\_names

column\_names: string\[]

List of member table columns or column expressions to be included in the join. Columns can be prefixed with 'table\_id.column\_name', where 'table\_id' is the table name or alias. Columns can be aliased via the syntax 'column\_name as alias'. Wild cards '' can be used to include all columns across member tables or 'table\_id.' for all of a single table's columns. Columns and column expressions composing the join must be uniquely named or aliased--therefore, the '\*' wild card cannot be used if column names aren't unique across all tables.

<ul>
  <li>Defined in [src/types.ts:1711](https://github.com/kineticadb/kinetica-api-typescript/blob/master/src/types.ts#L1711)</li>
</ul>

### `Optional`expressions

expressions?: string\[]

An optional list of expressions to combine and filter the joined tables. Corresponds to a SQL statement WHERE clause. For details see: expressions.

<ul>
  <li>Defined in [src/types.ts:1713](https://github.com/kineticadb/kinetica-api-typescript/blob/master/src/types.ts#L1713)</li>
</ul>

### join\_table\_name

join\_table\_name: string

Name of the join table to be created, in \[schema\_name.]table\_name format, using standard name resolution rules and meeting table naming criteria.

<ul>
  <li>Defined in [src/types.ts:1707](https://github.com/kineticadb/kinetica-api-typescript/blob/master/src/types.ts#L1707)</li>
</ul>

### `Optional`options

options?: Record\<string, string>

Optional parameters.

<ul>
  <li>Defined in [src/types.ts:1715](https://github.com/kineticadb/kinetica-api-typescript/blob/master/src/types.ts#L1715)</li>
</ul>

### table\_names

table\_names: string\[]

The list of table names composing the join, each in \[schema\_name.]table\_name format, using standard name resolution rules. Corresponds to a SQL statement FROM clause.

<ul>
  <li>Defined in [src/types.ts:1709](https://github.com/kineticadb/kinetica-api-typescript/blob/master/src/types.ts#L1709)</li>
</ul>


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.