Steve Perry

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.

Content

How can a MySQL query return data from multiple tables?

March 29, 2017

Learn how the JOIN technique can help you present information from two or more tables.

What is the difference between explicit and implicit JOINs in MySQL?

Learn the difference between explicit and implicit JOINs and understand which you should use in your MySQL project.

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