mysql表关联语句

-- users 表结构
CREATE TABLE users (
    id INT PRIMARY KEY,
    name VARCHAR(50),
    email VARCHAR(50)
);

-- orders 表结构
CREATE TABLE orders (
    id INT PRIMARY KEY,
    user_id INT,
    amount DECIMAL(10, 2),
    order_date DATE
);

-- 插入示例数据
INSERT INTO users (id, name, email) VALUES
(1, 'Alice', 'alice@example.com'),
(2, 'Bob', 'bob@example.com');

INSERT INTO orders (id, user_id, amount, order_date) VALUES
(1, 1, 100.00, '2023-01-01'),
(2, 1, 200.00, '2023-01-15'),
(3, 2, 150.00, '2023-02-01');

SELECT users.name, orders.amount, orders.order_date
FROM users
INNER JOIN orders ON users.id = orders.user_id;

SELECT users.name, orders.amount, orders.order_date
FROM users
LEFT JOIN orders ON users.id = orders.user_id;

SELECT users.name, orders.amount, orders.order_date
FROM users
RIGHT JOIN orders ON users.id = orders.user_id;