Left Anti Join
A left anti join returns records from the left input that do not have a match in the right input.
When the Join processor
performs a left anti join on our sample data using
customer_id as the
join field, the processor produces the following output:| customer_id | customer_name |
|---|---|
| 98 | Theo Barnes |