Example 1
Match employees to departments
Only rows with a matching department are returned. ORDER BY e.id keeps the example stable for validation.
Source table data Rows loaded before the example query runs.
Setup
CREATE TABLE departments (id INT, name VARCHAR(50));
CREATE TABLE employees (id INT, name VARCHAR(50), department_id INT);
INSERT INTO
departments (id, name)
VALUES
(1, 'Engineering'),
(2, 'Finance');
INSERT INTO
employees (id, name, department_id)
VALUES
(1, 'Ada', 1),
(2, 'Grace', 1),
(3, 'Linus', 2);Validated query Shared across supported engines.
SQL
SELECT
e.name,
d.name AS department
FROM
employees e
INNER JOIN departments d ON e.department_id = d.id
ORDER BY
e.id;Expected result Returned rows for the shared example.
| name | department |
|---|---|
| Ada | Engineering |
| Grace | Engineering |
| Linus | Finance |
The join output is identical across engines for this example.