Joining Tables in SQL

 Joining Tables in SQL

When working with multiple tables, we often need to combine data from them using JOIN statements. Here's an example:

sql

SELECT employees.name, departments.name

FROM employees

INNER JOIN departments

ON employees.department = departments.id;

In this example, we're selecting the name of each employee and their corresponding department name by joining the "employees" and "departments" tables on the "department" column.