When you choose left and right join I believe that provides the union but what if you want the intersection?

Avatar image
Aug 18, 2014
Lityx agent wrote
Unchecking both the boxes in the join dialog 3rd tab gives you the intersection (missing rows on either side don’t make it into the final result)