This site outlines in excellent detail how you create and use Joins. From inner joins to outer joins and unions, each option is explained and outlined. While the site focuses on SQL Server, additional tips and information are provided for other platforms where possible.
Read More - Register for Free Membership
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help