> ## 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.

# create_join_table

### create\_join\_table

<ul>
  <li>
    create\_join\_table(\
    &#x20;join\_table\_name: string,\
    &#x20;table\_names: string\[],\
    &#x20;column\_names: string\[],\
    &#x20;expressions?: string\[],\
    &#x20;options?: Record\<string, string>,\
    &#x20;callback?: [GPUdbCallback](https://docs.kinetica.com/content/api/nodejs/types/GPUdbCallback.md),\
    ): Promise\<[CreateJoinTableResponse](https://docs.kinetica.com/content/api/nodejs/interfaces/CreateJoinTableResponse.md)>

    Creates a table that is the result of a SQL JOIN.For join details and examples see: Joins. For limitations, see Join Limitations and Cautions.

    #### Parameters

    <ul>
      <li>
        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.
      </li>

      <li>
        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.
      </li>

      <li>
        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.
      </li>

      <li>
        `Optional`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.
      </li>

      <li>
        `Optional`options: Record\<string, string>

        Optional parameters.
      </li>

      <li>
        `Optional`callback: [GPUdbCallback](https://docs.kinetica.com/content/api/nodejs/types/GPUdbCallback.md)

        Optional callback function
      </li>
    </ul>

    #### Returns Promise\<[CreateJoinTableResponse](https://docs.kinetica.com/content/api/nodejs/interfaces/CreateJoinTableResponse.md)>

    Promise\<Types.CreateJoinTableResponse> - Promise resolving to the response

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

### create\_join\_table\_request

<ul>
  <li>
    create\_join\_table\_request(\
    &#x20;request: [CreateJoinTableRequest](https://docs.kinetica.com/content/api/nodejs/interfaces/CreateJoinTableRequest.md),\
    &#x20;callback?: [GPUdbCallback](https://docs.kinetica.com/content/api/nodejs/types/GPUdbCallback.md),\
    ): Promise\<[CreateJoinTableResponse](https://docs.kinetica.com/content/api/nodejs/interfaces/CreateJoinTableResponse.md)>

    Creates a table that is the result of a SQL JOIN.For join details and examples see: Joins. For limitations, see Join Limitations and Cautions.

    #### Parameters

    <ul>
      <li>
        request: [CreateJoinTableRequest](https://docs.kinetica.com/content/api/nodejs/interfaces/CreateJoinTableRequest.md)

        Request object containing the parameters for the operation
      </li>

      <li>
        `Optional`callback: [GPUdbCallback](https://docs.kinetica.com/content/api/nodejs/types/GPUdbCallback.md)

        Optional callback function
      </li>
    </ul>

    #### Returns Promise\<[CreateJoinTableResponse](https://docs.kinetica.com/content/api/nodejs/interfaces/CreateJoinTableResponse.md)>

    Promise\<Types.CreateJoinTableResponse> - Promise resolving to the response

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


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