create\_join\_table

create\_join\_table(
join\_table\_name: string,
table\_names: string\[],
column\_names: string\[],
expressions?: string\[],
options?: Record\<string, string>,
callback?: GPUdbCallback,
): Promise\<CreateJoinTableResponse>
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
- 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.
- 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.
- 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.
- Optionalexpressions: string\[]
  
  An optional list of expressions to combine and filter the joined tables. Corresponds to a SQL statement WHERE clause. For details see: expressions.
- Optionaloptions: Record\<string, string>
  
  Optional parameters.
- Optionalcallback: GPUdbCallback
  
  Optional callback function
Returns Promise\<CreateJoinTableResponse>

Promise\ - Promise resolving to the response
- Defined in src/GPUdb.ts:6089

create\_join\_table\_request

create\_join\_table\_request(
request: CreateJoinTableRequest,
callback?: GPUdbCallback,
): Promise\<CreateJoinTableResponse>
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
- request: CreateJoinTableRequest
  
  Request object containing the parameters for the operation
- Optionalcallback: GPUdbCallback
  
  Optional callback function
Returns Promise\<CreateJoinTableResponse>

Promise\ - Promise resolving to the response
- Defined in src/GPUdb.ts:6057

create\_join\_table

Parameters

Returns Promise\<CreateJoinTableResponse>

create\_join\_table\_request

Parameters

Returns Promise\<CreateJoinTableResponse>