You'll find article covering several types of database joins including Inner Joins and Outer Joins.
It is important to learn about both inner and outer joins and they have different matching behavior.
I would start out with our article Introduction to Database Joins.
This first article introduces the concept of joining tables. The focus is going to be more on the type of joins, not necessarily their syntax.
The later articles focus on the various types of joins. Through the narrative and examples you’ll become very comfortable with each one.
Some of our more popular articles include:
Find Joins Baffling?
Would you like some video instruction? If so, I encourage you to check my online course Join Together Now.
This course visually walks you through the concepts. Once you complete the course, you'll really get joins, and advance your career. Check this course today!
Recommended Database Join Articles
All the examples for this lesson are based on Microsoft SQL Server Management Studio and the sample databases AdventureWorks and WideWorldImporters. You can get started using these free tools using my guide Getting Started Using SQL Server