I was surprised about the outer joins in mySQL... I really thought there was a keyword already built in for that! I guess my mind was focused on Oracle when I was recording this video.
But from reading this link:
https://www.xaprb.com/blog/2006/05/26...
It turns out that getting a full join in mySQL requires you to use the UNION keyword between two tables.
The left, right, and inner join examples are almost self explanatory. If you have any questions, feel free to ask!