编辑代码

CREATE DATABASE test;
use test;
CREATE TABLE departments (
	id INT AUTO_INCREMENT PRIMARY KEY,
	department_name varchar(16),
	department_id INT
);

CREATE TABLE employees(
    id INT AUTO_INCREMENT PRIMARY KEY,
    name varchar(16),
    department_id INT
);

INSERT INTO departments (department_name, department_id) VALUES ('研发部', 101);
INSERT INTO departments (department_name, department_id) VALUES ('财务部', 102);
INSERT INTO departments (department_name, department_id) VALUES ('销售部', 103);
INSERT INTO departments (department_name, department_id) VALUES ('客服部', 104);

INSERT INTO employees (name, department_id) VALUES ('Jack', 101);
INSERT INTO employees (name, department_id) VALUES ('Lory', 104);
INSERT INTO employees (name, department_id) VALUES ('Lily', 105);
INSERT INTO employees (name, department_id) VALUES ('Tom', 103);
 
SELECT * FROM departments;
SELECT * FROM employees;

SELECT employees.name,departments.department_name
FROM employees
RIGHT JOIN departments
ON employees.department_id = departments.department_id;