有两个表orders（包含order_id、customer_id、order_date）和customers（包含custo...

测试积点老人

有两个表orders（包含order_id、customer_id、order_date）和customers（包含customer_id、customer_name），如何查询每个订单的订单号、客户姓名和订单日期？

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

kallinr

SELECT o.order_id, c.customer_name, o.order_date
FROM orders o
JOIN customers c ON o.customer_id = c.customer_id;

oliver.tang

select A.order_id, B.customer_name,A.order_date from orders A left join customers B on A.customer_id = B.customer_id

海海豚

SELECT o.order_id, c.customer_name, o.order_date
FROM orders o
JOIN customers c ON o.customer_id = c.customer_id;

jingzizx

SELECT o.order_id, c.customer_name, o.order_date
FROM orders o
JOIN customers c ON o.customer_id = c.customer_id;

你好浮戈

SELECT o.order_id, c.customer_name, o.order_date
FROM orders o
JOIN customers c ON o.customer_id = c.customer_id;

litingting0214

SELECT o.order_id, c.customer_name, o.order_date
FROM orders o
JOIN customers c ON o.customer_id = c.customer_id;