Right Anti Join
A right anti join returns records from the right input that do not have a match in the left input.
When the Join processor performs a right anti
join on our sample data using
customer_id
as the join field, the
processor produces the following output:customer_id | order_id | amount |
---|---|---|
342 | 1050945 | 126.05 |