Left Semi Join
A left semi join returns records that have matching values in both inputs, but does not include the merged data from both inputs. The results include only the data from the left input.
When the Join processor
performs a left semi join on our sample data using
customer_id as the
join field, the processor produces the following output:| customer_id | customer_name |
|---|---|
| 2 | Anna Smith |
| 47 | Raquel Trujillo |