From the course: Oracle Database 12c: Basic SQL
Join today to access over 24,700 courses taught by industry experts.
INNER JOIN - Oracle Database Tutorial
From the course: Oracle Database 12c: Basic SQL
INNER JOIN
- [Instructor] An inner join in SQL is a type of join that selects records that have matching values in both tables, that is, the intersection of both tables. So for example, if we will choose to perform an inner join between the employees and the department tables, based on the department ID column on both tables, we will instruct our database to only return records from the employees table where the department ID value exists in the department table. Let's see an inner join in action. We can use the example from our previous exercise. That is because in Oracle, by default, just specifying join or specifying inner join perform the exact same function. That's because by default, when joining two tables without specifying any specific type of join, is essentially an inner join. However, you are also free to explicitly specify that you choose to perform an inner join between the employees and the departments table.
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.
