What is the difference between an inner join and outer join in MySQL?

Learn how to join tables with non-matching data using inner or outer join in MySQL

By Steve Perry
March 29, 2017
Screen from "Question Video - Introduction to MySQL" Screen from "Question Video - Introduction to MySQL" (source: O'Reilly)

Inner joins are fairly straightforward and usually the first that are learned by beginning MySQL developers. Outer joins on the other hand, involve defining a dominant table when applying criteria, so that all entries in that table are visible along with those that match the criteria. In this video, Steve Perry first explains the different use cases associated with inner and outer joins, and then demonstrates how to execute each using MySQL statements. Beginner developers with MySQL enabled databases will learn step by step how to leverage the inner and outer join techniques to join tables with non-matching data.

Watch the full Introduction to MySQL course on Safari.

Learn faster. Dig deeper. See farther.

Join the O'Reilly online learning platform. Get a free trial today and find answers on the fly, or master something new and useful.

Learn more

Steve Perry teaches database design, MySQL, and the web development stack at Palomar College near San Diego. He’s worked in IT and software development since 1977, holds a Master’s degree in Education with an emphasis on adult education and online training, and is the author of multiple O’Reilly titles, including Learning SQL For Oracle and Dynamic Web Design with PHP and MySQL.

Post topics: Software Engineering
Post tags: Questions