Simple JOIN Example in SQL

Let's say you have two tables:

Employees

Departments

Example: INNER JOIN to get employee names with their department names

SELECT e.name, d.department_nameFROM Employees eINNER JOIN Departments d ON e.department_id = d.department_id;

Result:

Explanation:

• The query joins Employees and Departments using the matching department_id.

• Only rows with matching department_id in both tables are included.

If you want, I can show examples of other types of joins too!