Join is very common in SQL, but usually, the types used are inner join, left join, right join, and outer join. This article introduces what semi join and anti join are, using PySpark as an example.