> For the complete documentation index, see [llms.txt](https://docs.verbdata.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.verbdata.com/data-transformations/building-transformations/transformation-steps/join-data.md).

# Join Data

Enables joining data between tables in a variety of join types. Join data requires any combination of two tables, Child datasets or data views to be placed and connected on the Transformation Canvas. Join Types include: 

#### Inner Join 

Returns values that have matching values in both tables 

#### Left Outer Join 

Returns values from the left table and the matched records from the right table. 

#### Right Outer Join 

Returns values from the right table and the matched records from the left table. 

#### Full Outer Join 

Returns values when there is a match in either the left or right table. 

#### Cross Join 

Creates a row to connect every left table row to every right table row.

Output will be all columns from the left table followed by all columns from the right table.