mysql中自然连接的写法

-- 创建 employees 表
CREATE TABLE employees (
    employee_id INT PRIMARY KEY,
    name VARCHAR(50),
    department_id INT
);

-- 创建 departments 表
CREATE TABLE departments (
    department_id INT PRIMARY KEY,
    department_name VARCHAR(50)
);

-- 插入示例数据
INSERT INTO employees (employee_id, name, department_id) VALUES
(1, 'Alice', 101),
(2, 'Bob', 102),
(3, 'Charlie', 101);

INSERT INTO departments (department_id, department_name) VALUES
(101, 'HR'),
(102, 'Engineering');

SELECT employees.employee_id, employees.name, departments.department_name
FROM employees
NATURAL JOIN departments;