Can you show another INNER JOIN example?

Certainly! Here's another example of using INNER JOIN with two tables: employees and departments.

Tables

1. employees

   • employee_id
   • first_name
   • last_name
   • department_id

2. departments

   • department_id
   • department_name

SQL Query

The following query retrieves the first and last names of employees along with their corresponding department names:

SELECT employees.first_name, employees.last_name, departments.department_name
FROM employees
INNER JOIN departments ON employees.department_id = departments.department_id;

Explanation

• SELECT Clause: Specifies the columns to retrieve: first_name, last_name, and department_name.
• FROM Clause: Indicates the primary table (employees) to query from.
• INNER JOIN Clause: Joins the departments table on the condition that department_id in the employees table matches department_id in the departments table.

Result

The result set will include only those employees who belong to a department, and it might look like this:

In this example, only employees with a matching department_id in the departments table are included in the output.