---
title: Join
description: Combine two tables of data together based on a key
---

[Back to home](https://www.flow-wizard.com/knowledge)

- [ Analytical 
  
  ](https://www.flow-wizard.com/knowledge/analytical)
- [ Arithmetic 
  
  ](https://www.flow-wizard.com/knowledge/arithmetic)
- [ Data Prep 
  
  ](https://www.flow-wizard.com/knowledge/data-prep)
- [ Logical 
  
  ](https://www.flow-wizard.com/knowledge/logical)
- [ Charting Functions 
  
  ](https://www.flow-wizard.com/knowledge/charting-functions)
- [ Date Time 
  
  ](https://www.flow-wizard.com/knowledge/date-time)

# Join

## Combine two tables of data together based on a key

***Function:***

Join(table = *string*, join_table = *string*, how = *drop down*, left_on = *string*, right_on = *string*, new_table_name = *string*)

 

 

***Parameters:***

*Table: *Table name on which to perform function

*Join table:* Table to Join to the original Table

*How: *Type of join to perform (left, right, inner, outer

*Left on: *Key (column name) to match from left table 

*Right on: *Key (column name) to match from right table 

 

***Examples:***

***Left:*** Similar to a SQL left outer join. This will use only keys from left table

 

***Right: ***Similar to a SQL right outer join. This will use only keys from left table

 

***Outer: ***Similar to a SQL full outer join. This will use union of keys from both frames

 

***Inner: ***Similar to a SQL inner join. This will use an intersection of keys from both frames, preserve the order of the left keys.