https://sqlrelease.com/joins-in-sql-server
JOINs in SQL Server