> For the complete documentation index, see [llms.txt](https://docs.kuwala.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.kuwala.io/transformation-catalog/merging/join-by-id.md).

# Join by ID

### Description

With this transformation, you can join two tables by ID.

### Parameters

* left\_block
* right\_block
* column\_left
* column\_right
* join\_type
  * Options: inner, left, right, full\_outer