With this tutorial, you should be on your way to becoming proficient in SQL Server and Transact-SQL. Look at:https://www.techonthenet.com/sql_server/index.php
You can especially access the JOINS chapter at: https://www.techonthenet.com/sql_server/joins.php