Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Alteryx Joins in SQL - question about anti joins

Katie_K
8 - Asteroid

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

3 REPLIES 3
apathetichell
19 - Altair

YES.

OllieClarke
15 - Aurora
15 - Aurora

@Katie_K yup 👍

Katie_K
8 - Asteroid

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

Labels