---
title: "Intersect Sub Query"
canonical: "https://wiki.yellowfinbi.com/space/USER71/2031825/Intersect%20Sub%20Query"
format: markdown
---
> Macro (anchor)



> Macro (toc)

## Introduction

In this tutorial, we will walk through setting up an Intersect sub query. A good way to think about **Intersects** is - use them if you need a list of something that appears in two seperate lists.

In this scenario our main report will have a list of athletes that attended camps in the current year. We will then create a list of athletes from the previous year, and only return a list of athletes that are in both. This will effectively give us a list of athletes that are return customers from last year.

 

> Macro (html-bobswift)

 

## Initialise


> Macro (section)
> 
> > Macro (legacy-content)
> 
> > Macro (legacy-content)

> Macro (section)
> 
> > Macro (legacy-content)
> 
> > Macro (legacy-content)

> Macro (section)
> 
> > Macro (legacy-content)
> 
> > Macro (legacy-content)

## Master Query


> Macro (section)
> 
> > Macro (legacy-content)
> 
> > Macro (legacy-content)

## Intersect Query


### Create Intersect

> Macro (section)
> 
> > Macro (legacy-content)
> 
> > Macro (legacy-content)

### Configure Intersect

> Macro (section)
> 
> > Macro (legacy-content)
> 
> > Macro (legacy-content)

### Edit Settings

> Macro (section)
> 
> > Macro (legacy-content)
> 
> > Macro (legacy-content)

## Apply Filters


> Macro (section)
> 
> > Macro (legacy-content)
> 
> > Macro (legacy-content)

### Master Filter

> Macro (section)
> 
> > Macro (legacy-content)
> 
> > Macro (legacy-content)

### Sub Query Filter

> Macro (section)
> 
> > Macro (legacy-content)
> 
> > Macro (legacy-content)

## Save


> Macro (section)
> 
> > Macro (legacy-content)
> 
> > Macro (legacy-content)

> Macro (section)
> 
> > Macro (legacy-content)
> 
> > Macro (legacy-content)

> Macro (section)
> 
> > Macro (legacy-content)
> 
> > Macro (legacy-content)