MySQL学习笔记-Mosh【第三章】-Joining Multiple Tables

基本同法

利用连续的多个JOIN ON语句，将多个表进行链接。

SELECT
	o.order_id,
    o.order_date,
    c.first_name,
    c.last_name,
    os.name AS status
FROM orders o
JOIN customers c
	 ON o.customer_id = c.customer_id
JOIN order_statuses os
	 ON o.status = os.order_status_id;