การใช้ joins

SELECT
	ecomm_orders.order_id,
    ecomm_orders.order_items,
  	ecomm_order_details.order_status,
    ecomm_order_details.order_purchase_timestamp
FROM
	ecommerce.ecomm_orders
-- Join on the common order_id column
JOIN 
	ecommerce.ecomm_order_details ___ (___)
-- Order to show recent orders
ORDER BY ___ ___
LIMIT 10;