---
schema_version: "1"
id: e90aee8ccb09a3a9703cea30c3ffec49ca5c824bf5ba07fecc8977961b34c205
title: Join Operations
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/data/264-0-0/c360_a_batch_transform_join_operations.md
canonical_url: https://help.salesforce.com/s/articleView?id=data.c360_a_batch_transform_join_operations.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: b8a4f1b55e0d937e0f87108299938a4d56367d17855c7f53e492dd9c73481ddd
description: Batch data transforms support these join operations.
products:
  - Data 360
release: "264"
---
# Join Operations

Batch data transforms support these join operations.

- **[Lookup](https://help.salesforce.com/s/articleView?id=data.c360_a_batch_transform_join_lookup.htm&release=264.0.0&type=5)**  
    A lookup returns all rows from the left input data source object and only matching rows from the right object, the lookup source. To ensure that the grain of the results doesn’t change, the lookup output data includes one row for each row in the left object.
- **[Left Join](https://help.salesforce.com/s/articleView?id=data.c360_a_batch_transform_join_leftjoin.htm&release=264.0.0&type=5)**  
    Like a lookup, a left join includes all rows from the left input data source object and only matching rows from the right object. Unlike a lookup, a join includes all matched rows in the output data when multiple rows match.
- **[Right Join](https://help.salesforce.com/s/articleView?id=data.c360_a_batch_transform_join_rightjoin.htm&release=264.0.0&type=5)**  
    A right join includes all rows from the right and only matching rows from the left input data source objects. The join includes all matched rows in the data output when multiple rows match.
- **[Full Outer Join](https://help.salesforce.com/s/articleView?id=data.c360_a_batch_transform_join_outerjoin.htm&release=264.0.0&type=5)**  
    A full outer join includes all rows from the left and right input data source objects, regardless of whether they have matches. The join includes all matched rows in the output data when multiple rows match.
- **[Inner Join](https://help.salesforce.com/s/articleView?id=data.c360_a_batch_transform_join_innerjoin.htm&release=264.0.0&type=5)**  
    An inner join includes only matching rows from the left and right input data source objects. The join includes all matched rows in the output data when multiple rows match.
- **[Cross Join](https://help.salesforce.com/s/articleView?id=data.c360_a_batch_transform_join_crossjoin.htm&release=264.0.0&type=5)**  
    A cross join combines unrelated records and includes all rows from the left and the right input data source objects. Unlike other joins that use keys to find matches, the cross join pairs every row from one data source with every row of another data source.
- **[Considerations for Using Joins](https://help.salesforce.com/s/articleView?id=data.c360_a_batch_transform_join_considerations.htm&release=264.0.0&type=5)**  
    Unlike a lookup, a join creates a separate record for each match in the output data when multiple rows match. Before using a join, ensure that you understand the implications of duplicate rows.