mysql级联查询语句

-- 订单表 orders
CREATE TABLE orders (
    order_id INT PRIMARY KEY,
    product_id INT,
    quantity INT
);

-- 商品表 products
CREATE TABLE products (
    product_id INT PRIMARY KEY,
    product_name VARCHAR(255),
    price DECIMAL(10, 2)
);

SELECT o.order_id, p.product_name, p.price, o.quantity
FROM orders o
INNER JOIN products p ON o.product_id = p.product_id
WHERE o.order_id = 1;

-- 插入订单数据
INSERT INTO orders (order_id, product_id, quantity) VALUES
(1, 101, 2),
(1, 102, 1),
(2, 103, 3);

-- 插入商品数据
INSERT INTO products (product_id, product_name, price) VALUES
(101, 'Product A', 10.00),
(102, 'Product B', 20.00),
(103, 'Product C', 30.00);

SELECT o.order_id, p.product_name, p.price, o.quantity
FROM orders o
INNER JOIN products p ON o.product_id = p.product_id
WHERE o.order_id = 1;