---
schema_version: "1"
id: 077faeb6e397062073b9bce7143cd039bd69ec5ec330bb0fd905ee5caa76f6b4
title: Limitations and Considerations for Semi and Anti Joins
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/analytics/264-0-0/bi_explorer_data_join_considerations.md
canonical_url: https://help.salesforce.com/s/articleView?id=analytics.bi_explorer_data_join_considerations.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: d7bb550f10a44cbcd60999c810446d294df6e6356825b7bceb44e04bcb7a0cbe
description: Semi and anti joins are powerful tools for filtering data based on the existence of related records. To ensure accurate results and optimal performance, consider these specific behaviors when getting started.
products:
  - CRM Analytics
  - Cross Cloud
release: "264"
---
# Limitations and Considerations for Semi and Anti Joins

Semi and anti joins are powerful tools for filtering data based on the existence of related records. To ensure accurate results and optimal performance, consider these specific behaviors when getting started.

Unsupported Operations:

- `cogroup` and joins can't be used in the same query.
- Totals and subtotals aren't supported.
- Boolean filter logic isn't supported.
- Blends and joins can't be combined in the same query.

Optimizing Performance:

- Filter the second dataset before running a join. Join performance is directly proportional to the amount of data returned by the second dataset.
- Execute join statements before any projections on the query results. For example, if your query includes a `foreach` statement, such as `q = foreach q generate count(q1) as 'A';`, run it after the join.

Supported Filters

- Filters can be applied to both the primary and secondary datasets.

Join Limitations

 
| Limitation | Details |
| --- | --- |
| Dataset Limit | You can join a maximum of two datasets. For combining more datasets (up to six), consider using a blend. |
| Field Pairings | Up to five field pairings are allowed between datasets. |
| Order of Operations | Datasets must be joined before exploration. Join Data Source becomes unavailable if groupings, measures, or filters are added first. |
| Self-Joins | Combining rows within the same dataset is supported. When a filter is applied in a self-join, only one dataset is visible. Global filters are applied to the primary dataset in the join. |
| Primary Dataset Focus | Faceting and record-level actions are applied exclusively to the primary dataset. |