In the last chapter, we learned how to join tables together using the JOIN keyword . This was a type of join called an inner join, which displays records that exist in both tables being joined. The other type of join is an outer join.
What is an Outer Join?
An outer join is where two tables are joined together, but if there is no related record in one of the tables, the data from the other table is still shown.
Using our sample data and joining the employee table to the customer_meeting table, you saw customer_meeting and employee records. You didn’t see any customer_meetings that ...
