如果有三张表orders（包含order_id、customer_id、product_id）、customers（包含c...

测试积点老人

如果有三张表orders（包含order_id、customer_id、product_id）、customers（包含customer_id、customer_name）和products（包含product_id、product_name），查询每个订单的订单号、客户姓名和产品名称。

游客，如果您要查看本帖隐藏内容请回复

kallinr

SELECT o.order_id, c.customer_name, p.product_name
FROM orders o
JOIN customers c ON o.customer_id = c.customer_id
JOIN products p ON o.product_id = p.product_id;

oliver.tang

orders.customer_id=customers.customer_id  join orders.product_id = products.product_id

海海豚

SELECT o.order_id, c.customer_name, p.product_name
FROM orders o
JOIN customers c ON o.customer_id = c.customer_id
JOIN products p ON o.product_id = p.product_id;

jingzizx

SELECT o.order_id, c.customer_name, p.product_name
FROM orders o
JOIN customers c ON o.customer_id = c.customer_id
JOIN products p ON o.product_id = p.product_id;

你好浮戈

SELECT o.order_id, c.customer_name, p.product_name
FROM orders o
JOIN customers c ON o.customer_id = c.customer_id
JOIN products p ON o.product_id = p.product_id;

litingting0214

SELECT o.order_id, c.customer_name, p.product_name
FROM orders o
JOIN customers c ON o.customer_id = c.customer_id
JOIN products p ON o.product_id = p.product_id;