Pyspark for sql developers - joins

Hello everyone and welcome to my UA-cam channel.
In the continuation of the series of PySpark for SQL developers tutorials,
I want to show you how to use pyspark to perform different types of joins,
such as inner, outer, left, right, cross, semi, and anti joins.
I will also compare the pyspark code with the equivalent SQL code for SQL Server, so you can see the similarities
and differences between the two languages.