Alteryx Joins in SQL - question about anti joins

[Katie_K]

Hi folks - is the 'L' output anchor of a join tool the same thing as the output from a LEFT ANTI JOIN in SQL?

Similarly, is the 'R' output anchor the same thing as RIGHT ANTI JOIN in SQL?

Just want to confirm my understanding... thanks!!
Katie

[apathetichell · Accepted solution]

YES.

[OllieClarke · Accepted solution]

@Katie_K yup 👍

[Katie_K]

Thank you both @apathetichell and @OllieClarke for the speedy confirmation 😀