mysql关联一个表数据合并

-- 创建示例表
CREATE TABLE users (
    id INT PRIMARY KEY,
    name VARCHAR(50),
    email VARCHAR(50)
);

CREATE TABLE orders (
    id INT PRIMARY KEY,
    user_id INT,
    product VARCHAR(50),
    price DECIMAL(10, 2)
);

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

INSERT INTO orders (id, user_id, product, price) VALUES
(1, 1, 'Product A', 100.00),
(2, 1, 'Product B', 200.00),
(3, 2, 'Product C', 150.00);

-- 内连接示例
SELECT users.name, orders.product, orders.price
FROM users
INNER JOIN orders ON users.id = orders.user_id;

-- 左连接示例
SELECT users.name, orders.product, orders.price
FROM users
LEFT JOIN orders ON users.id = orders.user_id;

-- 右连接示例
SELECT users.name, orders.product, orders.price
FROM users
RIGHT JOIN orders ON users.id - orders.user_id;