# Join
<a name="API_Join"></a>

Specifies a transform that joins two datasets into one dataset using a comparison phrase on the specified data property keys. You can use inner, outer, left, right, left semi, and left anti joins.

## Contents
<a name="API_Join_Contents"></a>

 ** Columns **   <a name="Glue-Type-Join-Columns"></a>
A list of the two columns to be joined.  
Type: Array of [JoinColumn](API_JoinColumn.md) objects  
Array Members: Fixed number of 2 items.  
Required: Yes

 ** Inputs **   <a name="Glue-Type-Join-Inputs"></a>
The data inputs identified by their node names.  
Type: Array of strings  
Array Members: Fixed number of 2 items.  
Pattern: `[A-Za-z0-9_-]*`   
Required: Yes

 ** JoinType **   <a name="Glue-Type-Join-JoinType"></a>
Specifies the type of join to be performed on the datasets.  
Type: String  
Valid Values: `equijoin | left | right | outer | leftsemi | leftanti`   
Required: Yes

 ** Name **   <a name="Glue-Type-Join-Name"></a>
The name of the transform node.  
Type: String  
Pattern: `([^\r\n])*`   
Required: Yes

## See Also
<a name="API_Join_SeeAlso"></a>

For more information about using this API in one of the language-specific AWS SDKs, see the following:
+  [AWS SDK for C\$1\$1](https://docs.aws.amazon.com/goto/SdkForCpp/glue-2017-03-31/Join) 
+  [AWS SDK for Java V2](https://docs.aws.amazon.com/goto/SdkForJavaV2/glue-2017-03-31/Join) 
+  [AWS SDK for Ruby V3](https://docs.aws.amazon.com/goto/SdkForRubyV3/glue-2017-03-31/Join)