From the course: SQL for Non-Programmers
Join today to access over 23,100 courses taught by industry experts.
Other types of SQL joins - SQL Tutorial
From the course: SQL for Non-Programmers
Other types of SQL joins
Outside of the most commonly used inner join family, many other joins exist in SQL to meet your multi-query table needs. The difference between joins lies in which rows you want to return from your selected data tables. An inner join returns all of the rows that match the join conditions. But what if you wanted to return all of the rows that don't match the join conditions, or all of the rows from one table, and only those that match from another table? Let's review the different types of joins together that make these unique cases possible. Besides the inner join, another commonly used join is the left join, also called the left outer join. Unlike the inner join, which only returns rows that match between tables, a left join returns all of the rows from the left table and only the matching rows from the right table, leaving us with this. The left table is always the table immediately preceding the join keyword in your SQL code, and the right table is the table immediately after the…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.