Outer Join

An outer join is a way to combine two sets of data so that all entries from one or both sets are included, regardless of whether they have matching entries in the other. Imagine you have two lists—like a list of employees and a list of projects. An outer join will show all employees, even those not assigned to any project, and all projects, even those without employees. It helps you see everything from both lists, filling in gaps where there are no matches with empty spaces.