Not sure what the different JOINs mean in Azure Synapse Analytics and Azure SQL Database? Patrick walks you through the different types to get you on the right path!

Joins (SQL Server)
https://docs.microsoft.com/sql/relational-databases/performance/joins?view=sql-server-ver16